How To Recover Sql Server Password

When you are forgot your password in sql server authentication nothing to worry.

First open your Microsoft SQL Server Management Studio.

Select ServerName and first select Authentication type is Window Authentication and Connect.

sql server

Now showing Object Explorer in left side.

In Security > Logins > Select your sql server authentication username.

And right click on username and select properties. 

sql server management studio

Now open login properties pop up and here you are set new password.

sa

Enjoy..!