Menu
I just forgot the password. Can anyone help me how to get back the password.
639
Type sql server management studio into Start, then click Microsoft SQL Server Management Studio 17 at the top of the Start window. Select the correct authentication. Click the "Authentication" drop-down box, then click SQL Server Authentication in the menu. Log in with the new user's credentials.
The sa user is a SQL Server login and its password is encrypted and stored in the DMV sys. sql_logins (Database Management View) in the master database.
The remote instance of MS SQL / SQL Server has the default 'sa' account enabled without any password.
There is no way to get the old password back. Log into the SQL server management console as a machine or domain admin using integrated authentication, you can then change any password (including sa).
Start the SQL service again and use the new created login (recovery in my example) Go via the security panel to the properties and change the password of the SA account.
Now write down the new SA password.
87
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
