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