Reset sa password in MS SQL

22 Aug

If you have forgotten sa password and don’t have sysadmin rights, you can do the following:

  1. Download pstools (psexec) from http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx
  2. Start cmd with administrator  (run as administrator) and run this command:
    • PsExec -s -i "C:\Program Files (x86)\...\ssms.exe"
  3. Login with the default suggested username (NT AUTHORITY\SYSTEM) and add yourself as sysadmin

 

Read more

http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/

http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/

http://www.wikihow.com/Reset-SA-Password-in-Sql-Server

http://sqlserver-help.com/category/security/sa-password-lost/

http://www.pressleypress.com/blog/?p=785

http://dba.stackexchange.com/questions/31660/cannot-connect-to-sql-server-in-single-user-mode/31666#31666

 http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: