How To Recover Lost SA Password In SQL Server
If you’ve forgotten the sa password for your SQL server, Sure you are in a panic.But Fear not, you can reset the password and again you have access to sa account by using the New query window in the Management Studio.
- Open Sql-Server management studio with window authentication.
- Open New query window.
Use master GO ALTERLOGIN [sa] WITHDEFAULT_DATABASE=[master] GO USE [master] GO
ALTERLOGIN [sa] WITHPASSWORD=N'test@123'