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


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. ?


Basit Khan

more ▼

asked Jul 24, 2012 at 11:34 AM in Default

avatar image

basit 1
509 57 65 91

Which version of SQL Server Express?

Jul 25, 2012 at 07:49 AM ThomasRushton ♦♦

2008 version

Jul 25, 2012 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, 2012 at 07:56 AM

avatar image

ThomasRushton ♦♦
42.4k 20 60 54

...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, 2012 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, 2012 at 01:22 PM basit 1

The article I mentioned should have been helpful in that case.

Jul 27, 2012 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, 2013 at 09:41 AM

avatar image


(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Jul 24, 2012 at 11:34 AM

Seen: 6352 times

Last Updated: Aug 05, 2014 at 02:54 AM

Copyright 2018 Redgate Software. Privacy Policy