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.
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