Thursday, December 21, 2017

Reset SA Password in Sql Server any version

Reset SA Password in Sql Server any version


1st way : using command prompt  


Step 1: Open command prompt
Step 2: write osql -L  and hit enter
Step 3:  write osql -S ACHARYA\MSSQLSERVER2017 -E  and enter
Step 4:  write sp_password NULL, newpassword, 'sa'  and enter
Step 5:  write GO  and enter





Another way 

Connect to your instance of SQL Server via Windows Authentication



Then navigate to security>Logons>"the user for us sa, " and right click and open properties. 



then  change the password as shown in step 2. then click OK. 





No comments:

Post a Comment