Posts

Showing posts from February 16, 2013

RECOVERING SQLSERVER "SA" LOGIN PASSWORD

Image
The time may occur that you may forget or lost your sql server “ sa ” or “ sysadmin ” login’s password.  This process will give you an opportunity for retaining forgot or lost password of your sqlserver’s “ sa ” login. Select “SQL SERVER CONFIGURATION MANAGER” from start menu.   2.  Select SQLSERVER from the left panel and right click on “SQL SERVER (MSSQLSERVER)” from the right panel.   Select stop from the context menu appeared for stopping the sqlserver service. 3.  After stopping the service again right click on the SQLSERVER service and select properties.   In properties window select advanced tab.   Now for the startup parameter add “-m;” at the starting position of the string as show in the below diagram. 4.  After changing the startup parameter again start the sqlserver service. 5.  Now open the command prompt and from here we will create a user with the sysadmin role and by using this users login we are going to change the sa log