how to reset sql server sa password

how to recover or reset the sa password.

It is very easy to reset or recover the sa password.                                   Stay COOL!................

just follow the below instructions,

1. Go to "SQL Server Configuration Manager ".
2. Stop the "SQL Server" service.
3. Right click on "SQL Server" then 'Properties', Go to "Advanced Tab".
4. Click on "Startup properties" and type "-m;", click Apply and OK.

Add caption

5. Start  the "SQL Server" service.
6. Go to "Run" type "cmd" (with Administrative privileges)
or  Go to "Start" , "All Programs" , "Accessories" ,  Right click on "Command Prompt" , click "Run as Administrator".
7. Type "sqlcmd"     or     "sql -S SQLSERVER\INSTANCE".
                1> sp_password @new = ’newpassword’, @loginame = ‘sa’
                2> Go
                1> exit

Add caption

8. Go to "SQL Management Studio"
And login as  "(Local)" with "sa" account.

Keep Enjoying!.....