To reset the password of a MS SQL Server account, first log into the server with that account:

Screenshot of MS SQL Server "Connect to Database Engine" dialog box


In the new query window, run the following query, replacing MyAccountName, MyNewPassword, and MyOldPassword with the appropriate values:

Screenshot of the command:  ALTER LOGIN [MyAccountName] WITH PASSWORD = 'MyNewPassword' OLD_PASSWORD = 'MyOldPassword';

More information on the ALTER LOGIN  T-SQL command can be found in the Microsoft documentation at:



Article number: 
Last updated: 
May 8, 2019