Using the SQL Server Management Studio to change the password for the SQL Server administrator - Metasys - LIT-12011177 - M4-ADSTK-PC - M4-ADXTK-RCK - M4-ADXTK-TWR - ADS/ADX Turnkey - 12.0

ADS/ADX Turnkey User Guide

Product name
ADS/ADX Turnkey
Document type
User Guide
Document number
LIT-12011177
Version
12.0
Revision date
2022-05-20

Procedure

  1. Click Start > All Programs > Microsoft SQL Server 2017 > SQL Server Management Studio.
    Note: If Microsoft SQL Server Management Studio 2018 is installed, instead click Start > All Programs > Microsoft SQL Server Tools 18 > Microsoft SQL Server Management Studio 18.
  2. In the Connect to Server window, select the local server name from the Server name list, and then select SQL Server Authentication from the Authentication list.
  3. Enter sa for the login name, and then enter the default SQL Server administrator password.
    Note: To identify the default SQL Server administrator password, refer to the documentation that ships with the Turnkey.
  4. Click Connect to access the server.
  5. In Object Explorer, expand Security > Logins.
  6. Right-click the sa user, and then click Properties.
  7. In the Login Properties window, enter a new password in the Password field. Enter the password again in the Confirm Password field.
    Note: To comply with the SQL Server complex password policy, enter a password that is at least eight characters long and contains characters from three of the following categories: uppercase letters A to Z, lowercase letters a to z, numbers 0 to 9, and non-alphanumeric characters. However, do not use the following characters: &, <, >, or /.
  8. Click OK.