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.

Now showing Object Explorer in left side.

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

And right click on username and select properties. 

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

Enjoy..!