Categories
Sql Server

How To Recover Lost SA Password In SQL Server

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.

  1. Open Sql-Server management studio with window authentication.
  2. Open New query window.
Use master GO ALTERLOGIN [sa] WITHDEFAULT_DATABASE=[master] GO USE [master] GO 
ALTERLOGIN [sa] WITHPASSWORD=N'test@123'