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: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-login-transact-sql

 

 

Article number: 
115461
Last updated: 
May 8, 2019