How to reset the password of the ‘sa’ account in SQL

How to reset the password of the ‘sa’ account in SQL

Saturday - 05/10/2024 00:00
If you accidentally forgot the default SA account password in SQL SERVER then here is the solution for you to reset it.
Go to SQL Server 2016 Configuration Manager > SQL Server Service > SQL Server (MSSQLSERVER).
sql server

– Right-click and select Properties > select the Startup Parameters Tab > add the value: -m
m sql

– Restart sql > access with Windows Authentication
– Select Security > Logins > sa > change the password
sa sql

– After changing the password, go back to the step of adding the value: -m > remove it and restart SQL.
 Tags: sa sql

  Reader Comments

Security Code   
You did not use the site, Click here to remain logged. Timeout: 60 second