How to change mssql user password manually?

Rohan Wiese

Member
Two free methods to change mssql user password manually

Option 1. Change SQL Server MSSQL User Password with Management Studio
Step 1. Open SQL Server Management Studio
Step 2. Open a new query
Step 3. Type the following commands and execute:
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’ MUST_CHANGE
GO
Then the new password is set for your SQL Server sa account.

Option 2. Change MSSQL User Password with SQL Password Changer Tool
  1. Runs SQL User Password Changer Tool
  2. Add Password Protected MSSQL Database File (.mdf)
  3. Click on Change button to Change or Reste your User Password
Thanks & Regards

Rohan Wiese
 
Top