MSSQL parameters

The following table lists Control‑M/Server database parameters for the MSSQL environment.

Parameter

Description

Server Host Name

Defines the host name of the machine where the SQL Server resides. If you install the dedicated SQL Server, the value is the current machine. For a silent installation the value of this parameter is blank, and the installation procedure uses the name of the current machine.

Query Port Number

-and-

Backup Port Number

Defines two TCP/IP ports for communication between Control‑M/Server and the SQL Server. The port numbers must be different from each other. If these port numbers are already used by an existing application, choose other values, each in the range 1024 to 65534 inclusive.

Default: 7102 and 7103

Refresh Type: Recycle

System Administrator (SA) Password

Defines the password (6 to 30 alphanumeric characters) for the database administrator (user sa). The characters you enter, do not echo for security reasons. Control‑M/Server utilities uses the password to access restricted sections of the Control‑M/Server database.

Default: password

Control‑M/Server Database Name

Defines the name for the Control‑M/Server database, which must be unique.

If you use unique values for owner name, database name, and device assignments, a new database is built on the server. By using an existing owner name, database name, and device assignment, you delete and recreate the database elements.

Every computer type uses a different character set for the server.

Default: ctrlm

Control‑M/Server Database Owner

Defines the database name of the Control‑M/Server database owner. The installation script creates this user in the database. Control‑M/Server uses the name when accessing its database.

Default: ctrlm

Control‑M/Server Database Owner (DBO) Password

Defines the password of the Control‑M/Server database owner (6 to 30 alphanumeric characters). The characters you enter, do not echo for security reasons. The first character must be a letter (A – Z). Control‑M/Server uses the password for processes and utilities to access the Control‑M/Server database.

Default: password

Data Device Logical Name

Defines the name of the device where the Control‑M/Server database is located.

Default: ctrlm_ux

Data Device Path

Defines the full path name of the Control‑M/Server database.

Default: c:\<sql_dir>\data\ctrlm_ux

Data Device Size

Defines the amount of space (MB) allocated for the data portion of the Control‑M/Server database.

Default: 75 (MB)

Log Device Logical Name

Defines the name of the device where the Control‑M/Server database is located.

Default: ctrlm_log

Log Device Location

Defines the full path name where the Control‑M/Server database log is located.

Default: c:\<sql_dir>\data\ctrlm_log

Log Device Size

Defines the amount of space (MB) to allocate for the Control‑M/Server database log.

Default: 25 (MB)

 

Parent Topic

Database parameters