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

Question

question

basit 1 asked Jul 24, '12

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

login authentication sa

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

Which version of SQL Server Express?

0 ·

basit 1 commented · Jul 25, 2012 at 01:23 PM

2008 version

0 ·

Answer 1 · 2012-07-25T07:56:18Z

ThomasRushton answered Jul 25, '12

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

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

robbin commented · Jul 25, 2012 at 09:55 AM

...before proper application of caffeine... No wonder you missed the important point that there may be no sysadmin user ;) So this [thread][1] may be helpful. It may sound like a strange question to caffeine cravers, but what is kinda **proper** application of caffeine???? [1]: http://www.rodcerrada.com/post/2011/04/20/Recovering-SQL-Server-Built-in-Administrator-Access-to-Database.aspx

0 ·

basit 1 commented · Jul 25, 2012 at 01:22 PM

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

0 ·

robbin commented · Jul 27, 2012 at 07:14 AM

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

0 ·

Answer 2 · 2013-04-25T09:41:31Z

avirasimon answered Apr 25, '13

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/**][1] 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. [1]: http://howtogetpasswordofsqlserver.wordpress.com/2013/03/08/how-to-get-password-of-sql-server-mdf-file/

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question