x

How to change SA Password and Authentication mode of SQL Server ?

Hi,

Today i got a very strange issue in my current organization.

We have one SQL Server Express Edition has installed on our server, The Server was installed by the Vendor Company . The Installation has done by using the Wndow Authentication Mode only and only single Login id has created ( Americas-Test ) which has Public access on the server. Now i want to change the SA Password and Also want to change the Mixed mode Authentication and how to create the SYSADMIN User on the server.

Do the User have public access ( Americas-test ) can change the authentication mode

Or How can i change the SA Password when there is no SYSADMIN User. ?

Thanks

Basit Khan
more ▼

asked Jul 24 '12 at 11:34 AM in Default

basit 1 gravatar image

basit 1
449 49 61 81

Which version of SQL Server Express?
Jul 25 '12 at 07:49 AM ThomasRushton ♦
2008 version
Jul 25 '12 at 01:23 PM basit 1
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

First off, have you got something like SQL Server Express Management Studio?

Connect to the server. Right-click, properties. You can change the security mode from that dialog. You'll need to restart SQL Server for the change to take effect. Once you're in mixed mode, you should have access to the sa user.

Please note: answer provided before proper application of caffeine, and so may not be 100% accurate... ;-)
more ▼

answered Jul 25 '12 at 07:56 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.3k 13 20 44

...before proper application of caffeine... No wonder you missed the important point that there may be no sysadmin user ;) So this thread may be helpful.

It may sound like a strange question to caffeine cravers, but what is kinda proper application of caffeine????

Jul 25 '12 at 09:55 AM robbin
For changing the mixed mode there must be a user which have Sysadmin right....we donot have any user which have sysadmin Access on the server
Jul 25 '12 at 01:22 PM basit 1
The article I mentioned should have been helpful in that case.
Jul 27 '12 at 07:14 AM robbin
(comments are locked)
10|1200 characters needed characters left

Change SA password of your SQL Server 2008 version then takes the reference from this http://howtogetpasswordofsqlserver.wordpress.com/2013/03/08/how-to-get-password-of-sql-server-mdf-file/ site which is really helpful for you. You can easily change it with new one which is easy and quick process that will greatly increase the security of your SQL Server database.

more ▼

answered Apr 25 '13 at 09:41 AM

avirasimon gravatar image

avirasimon
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x81
x18
x7

asked: Jul 24 '12 at 11:34 AM

Seen: 3287 times

Last Updated: Apr 25 '13 at 09:41 AM