Configure IBM Sterling Control Center Monitor to use Microsoft SQL Server database

To configure IBM® Sterling Control Center Monitor to use Microsoft SQL Server database, you need to specify database connection details.

Specify database connection details for the two different IBM Sterling Control Center Monitor database using one of the following methods:

On Windows operating systems - Either as part of the installation or later when configCC is run, you can specify the database connection details for the IBM Sterling Control Center Monitor database.
On Linux® and UNIX operating systems - After installing IBM Sterling Control Center Monitor, when you run configCC, you can specify the database details for the IBM Sterling Control Center Monitor database.

Important: Ensure you have the correct database version and supported JDBC driver file. For more information, see Detailed System Requirements.

Provide the following database connection information when you are configuring IBM Sterling Control Center Monitor to use Microsoft SQL Server database:

DB connection information	Description	Notes
Database Host Name		For MS SQL Server 2005, if you need to connect to a named instance of SQL server, use the format servername;instancename. Example: `CSGPQ2;SCCINSTANCE`
Database port	The port number on which database server listens on	Typically, it is 1433. Ensure that the database server is listening on that port. From the server where you are installing the IBM Sterling Control Center Monitor engine, try to establish a “telnet” connection to the database host and port. `telnet <<dbhost>> <<dbPort>>`
Database User ID
Database password
Database Name
JDBC Drivers	mssql-jdbc-6.2.2.jre8.jar mssql-jdbc-6.4.0.jre8.jar mssql-jdbc-7.0.0.jre8.jar mssql-jdbc-7.2.2.jre8.jar mssql-jdbc-7.4.1.jre8.jar	The drivers can be downloaded from the following location: Microsoft JDBC Driver for SQL Server