Enhanced SQL Server password management

Starting with
Application Code Manager
 version 5.01.00, the
SQL Server
 password is enhanced for security. The static, hardcoded password is replaced with a strong, randomly generated password during installation.

Installation and
SQL Server
 password creation

  • If you select
    SQL Server
     for installation:
    • Application Code Manager
       installs
      SQL Server
      .
    • Application Code Manager
       creates a strong password for the "sa" user. The password is 24 characters long, including uppercase, lowercase, digits, and special characters.
    • The Windows Registry encrypts and stores the password.
  • If you don't select
    SQL Server
     for installation:
    • Application Code Manager
       doesn't change existing
      SQL Server
       settings or delete databases.
    • The setup continues with the current
      SQL Server
       configuration.

Password policy enforcement

If
Application Code Manager
 detects that the "sa" account is using a well-known or static default password from
Application Code Manager
 version 5.00.00 or earlier:
  • You are required to change the password using
    SQL Server
     Management Studio before continuing.

Password changes and compatibility

If you change the "sa" password using
SQL Server
 Management Studio:
  • The password generated during the
    Application Code Manager
     installation is no longer valid. You must use the new password for all future connections.

Handling errors and special cases

  • If the "sa" password generated by
    Application Code Manager
     doesn't work:
    • Enter the current "sa" password manually when prompted. If you don't know the password, contact your
      SQL Server
       administrator.
  • If
    Application Code Manager
     is uninstalled:
    • The "sa" password generated by
      Application Code Manager
       remains in the Windows Registry. Don't delete the registry key unless you are sure that the "sa" password has been updated using
      SQL Server
       Management Studio.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal