Using the Command Prompt 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

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

Procedure

  1. To open Command Prompt with administrative access rights, click Start, type cmd, right-click the Command Prompt search result, and then click Run as administrator.
  2. In the Command Prompt window, type sqlcmd, and then press Enter.
    The sqlcmd software starts and displays the following command prompt: 1>
  3. Type the following commands. Press Enter after each command, and replace newpassword with the new password.
    Note: To comply with the SQL Server complex password policy, choose a new 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 /.
    1. sp_password @new = 'newpassword', @loginame = 'sa'
    2. go
    3. exit