Configuring Control Center Director to use SQL Server databases
To specify database connection details, on Linux and UNIX operating systems run config.sh and provide the following database connection information:
| Database Connection Parameter | Description |
|---|---|
| Database Host Name |
For MS SQL Server 2016, to connect to a named instance of SQL server use the format
Example: |
| Database port | The port number on which database server listens on. Default: 1433. To ensure that the database server is listening on that port 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-7.2.2.jre8.jar mssql-jdbc-7.4.1.jre8.jar mssql-jdbc-8.2.2.jre8.jar mssql-jdbc-8.4.1.jre8.jar mssql-jdbc-9.2.1.jre8.jar mssql-jdbc-9.4.0.jre8.jar |