Question

How can I change the 'sa' password in MSSQL?

 

Answer

  1. Open SQL Server Management Studio
  2. Log in to SQL using "Windows Authentication" (this requires SQL admin permissions to have previously been given to your Windows account, usually during the SQL install)
  3. In the Object Explorer panel, expand Security, the Logins
  4. Right-click the "sa" account and click Properties
  5. Specify a new password and click OK

 

Overview

The 'sa' user password is need to provide the initial connection between MSSQL and any AccessData product.