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

Product name
ADS/ADX Turnkey
Document type
User Guide
Document number
Revision date


  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