Get all MS SQL Data recovery and repair measures. Know how to protect the SQL Database from corruption. Tips and tricks to recover your corrupt Microsoft Server database files. Restore SQL database easily with step by step recovery process and methods.
This Blog is designed to provide SQL Database error in short and informative way, so that SQL error recovery and database recovery can be done without much hurdle
Saturday, 28 September 2013
Reset MS SQL Server Password in Microsoft SQL Server Application
If you wish to change your MS SQL Server password then
perform the bellow mentiond procedure:-
Open the Microsoft SQL Server Management Studio
Connect with the database
Click the Object Explorer
Expand the Security folder, After that
Expand the Login folder
There you will find “sa account”, right click on it and go
to the properties.
A new window will open up just perform the SQL Server Password Reset here.
Note* Though you may not need to restart the MS SQL Server
after the password change but if you feel you can restart the server and check if
the password you set is allowing you to access the database.
If someone lost access to their database because of failed authentication
due to incorrect password they can take the help of a SQL Server Password Reset tool to get back
access to the database.