Modify the Default Password for User ca_itrm When Microsoft SQL Server 2005 is Used on Windows

Document ID : KB000055519
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

The Unicenter Desktop and Server Management (DSM) Documentation contains the following section:

Modify Default Password When Microsoft SQL Server is Used on Windows

To modify the default password for user ca_itrm when Microsoft SQL Server is used on Windows

  1. Go to the system where Microsoft SQL Server is running.

  2. Open Windows Start, Programs, Microsoft SQL Server, Enterprise Manager.

  3. Open the SQL Server local MDB database, Security, Logins.

  4. Select the ca_itrm user and modify the password to the preferred one.

  5. Go to the system where the DSM manager has been installed.

  6. Run cadsmcmd setDBCredentials passwd= new_password.

  7. Run caf stop.

  8. Run caf start.

Note: For SQL 2005 there is no longer an Enterprise Manager and password policy must be taken into account

Solution

Enterprise Manager

In SQL Server 2005 the Enterprise manager is replaced with the SQL Server Management Studio accessed via Start, Programs, Microsoft SQL Server 2005, SQL Server Management Studio

Password Policy

The following is the description of password policy from the SQL server 2005 books online

When running on Windows Server 2003 or above, SQL Server 2005 can use Windows password policy mechanisms.

SQL Server 2005 can apply the same complexity and expiration policies used in Windows Server 2003 to passwords used inside SQL Server. This functionality depends on the NetValidatePasswordPolicy() API, which is only available in Windows Server 2003 and above.

Password Complexity

Password complexity policies are designed to deter brute force attacks by increasing the number of possible passwords. When password complexity policy is enforced, new passwords must meet the following guidelines.

The password does not contain all or "part" of the user's account name. Part of an account name is defined as three or more consecutive alpha-numeric characters delimited on both ends by "white space" (space, tab, return, etc.) or any of the following characters: , . - _ #

The password is at least six characters long.

The password contains characters from three of the following four categories:

English uppercase letters (A - Z)

English lowercase letters (a - z)

Base 10 digits (0 - 9)

Non-alphanumeric (For example: !, $, #, or %)

Password Expiration

Password expiration policies are used to manage the lifespan of a password. When password expiration policy is checked, users are reminded to change old passwords and accounts with expired passwords are disabled.

Policy Enforcement

Password policy is enforced on a per-login basis. Use ALTER LOGIN to configure policy application. The following rules apply to the configuration of password policy enforcement.

When CHECK_POLICY is changed to ON:

When the DSM installer creates the ca_itrm login in SQL 2005 it has the following properties:

Figure 1

The Default Password for ca_itrm therefore adheres to the password policy.

When changing the ca_itrm password it is necessary to use a new password that adheres to this policy or to uncheck the "Enforce password policy" CA Strongly recommends to use a new password that meets the password policy.

The Instructions for modifying the default password for SQL 2005 are therefore

Modify Default Password When Microsoft SQL Server 2005 is Used on Windows

To modify the default password for user ca_itrm when Microsoft SQL Server 2005 is used on Windows

  1. Go to the system where Microsoft SQL Server is running.

  2. Open Windows Start, Programs, Microsoft SQL Server 2005, SQL Server Management Studio.

  3. Logon to the Local Server Instance.

  4. Expand Security, Logins.

  5. Select the ca_itrm user and modify the password to the preferred one adhering to password policy.

  6. Go to the system where the DSM manager has been installed.

  7. Run cadsmcmd setDBCredentials passwd= new_password.

  8. Run caf stop.

  9. Run caf start.