Skip to main content
Reset SQL Server 2012 sa password when sa password is lost or no sysadmin
- Stop SQL server via Service Manager.
- Start SQL server via command prompt (with Admin privilledge)
- net start MSSQL /c /m /T3608 OR
- net start /c /m /T3608
- Use SQLCMD
- sqlcmd -S MSSQL
- Enter the below SQL
- ALTER LOGIN sa with password='password', check_policy=off;
- go
- ALTER LOGIN sa enable;
- go
- shutdown with nowait;
- go
- Then start the SQL server again as normal (e.g. via Service Manager).
- Then you can access the DB using sa.
Comments