Loading

How To Recover Sql Server Password

Malvik Bhavsar

1 Comment

Join the conversation! Your thoughts help the community grow.

pertti jarva11y ago
This only works in case your current windows account is also sa in the SQL Server which probably shouldn't be the case in normal installations. Of course if it's just your own setup on your own laptop that's a different thing.

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.

sql server management studio

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

Enjoy..!