How to change password for MS SQL admin user?

Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you have working sa user password.

  1. Login to MSSQL server by using current sa password through MS SQL management studio.

  2. In left pane of Object Explorer, Click on Security -> Logins-> sa

    Reset sa User Password in MS SQL Server

  3. Right click on sa and click on Properties. It will open-up screen for password change.

    Reset MSSQL Admin Password

  4. Change password and press OK button.

Related Articles

How to Install Advanced Features on Existing Instance of MS SQL Server?

If you have chosen MS SQL Server to be installed in Windows VPS while placing an order, you'll...

How to Fix Error "Could not allocate space for object 'X' in database"?

Error Message Could not allocate space for object 'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in...

Fix :: Reporting Service Error After Upgrade From MS SQL server from 2008 to 2012

Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities....

How to set database size limit on MSSQL Server?

Please refer to the following steps to set the database size limit for Microsoft SQL Server....

How to take MSSQL database offline or bring it online?

Sometimes, you come across to a situations when you are required to physically move the database...

  • 1 Users Found This Useful

Was this answer helpful?