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

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

basit 1
439 ● 36 ● 54 ● 80

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)

2 answers:

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

For SQL 2005: http://www.microsoft.com/en-us/download/details.aspx?id=8961
For SQL 2008: http://www.microsoft.com/en-us/download/details.aspx?id=7593

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... ;-)

answered Jul 25 '12 at 07:56 AM

ThomasRushton ♦
29.4k ● 6 ● 9 ● 36

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

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.

answered Apr 25 at 09:41 AM