Home>Alibaba Cloud Solutions>Data Migration>How to Reset MS SQL Server Pas...
Reply
« Back to list

Shreyansh
Shreyansh
Senior Engineer
Senior Engineer
  • UID12865
  • Fans1
  • Follows0
  • Posts365
Send
Reads:675Replies:0

How to Reset MS SQL Server Password?

Created#
More Posted time:May 27, 2023 18:36 PM
Method 1. Reset MS SQL Server Password Using SQL Server Management Studio
To reset the password for a Microsoft SQL Server, you can follow these steps:
  • Open SQL Server Management Studio (SSMS), and connect to the SQL Server instance using Windows Authentication or any other authentication method for which you have the necessary privileges.
  • Once connected, open a new query window by clicking on "New Query" in the toolbar.
  • In the query window, execute the following SQL command to change the password for the desired user (replace <username> and <new_password> with the appropriate values):
            ALTER LOGIN <username> WITH PASSWORD = '<new_password>';
  • After executing the query, you should see a message indicating that the command completed successfully.
  • Test the new password by attempting to connect to the SQL Server using the updated credentials.
Please note that you should have sufficient privileges to execute this operation. Additionally, make sure to use a strong password that meets the security requirements of your organization.
Method 2. Recovering MS SQL Password Using Automated Tool
Another way to reset MS SQL Server Password is SysInfo SQL Server Password Recovery Software. It provides a reliable solution for recovering and resetting passwords for SQL Server users and system administrator accounts. This comprehensive tool enables users to effortlessly unlock their SQL Server user accounts and establish new passwords in cases where the original password has been misplaced or forgotten. With this powerful recovery software, both encrypted and unencrypted passwords can be cracked, ensuring a successful retrieval of access to user accounts. The program also extends its support to recover multilingual passwords from MDF files. Furthermore, SysInfo SQL Server Password Recovery offers wide compatibility, catering to various MS SQL Server versions including 2014, 2012, 2008 R2, 2008, 2005, and 2000.
Likes0
Report Replies
Guest