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

  1. Connect with the database
  2. Click the Object Explorer
  3. Expand the Security folder, After that
  4. Expand the Login folder
  5. 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.

No comments:

Post a comment