MS-SQL Server data source configuration

Use this information to create an MS_SQL Server data source.

Table 1. General settings for MS-SQL Server data source window
Window element	Description
Data Source Name	Enter a unique name to identify the data source. You can use only letters, numbers, and the underscore character in the data source name. If you use UTF-8 characters, make sure that the locale on the Impact Server where the data source is saved is set to the UTF-8 character encoding.
User name	Type a user name with which you can access the database.
Password	Type a password that allows you access to the database. As you type, the characters are replaced with asterisks (*).
Maximum SQL Connection	For maximum performance set the size of the connection pool as greater than or equal to the maximum number of threads that are running in the event processor. Important: Changing the maximum connections setting in an SQL data source requires a restart of the Impact Server. For information about viewing existing thread and connection pool information, see the information in the Netcool/Impact Administration in the section Command-Line tools, Event Processor commands. See the Select PoolConfig from Service where Name='EventProcessor'; Important: In a clustered environment, the event processor configuration is not replicated between servers. You must run the Select PoolConfig from Service where Name='EventProcessor'; command on the primary and the secondary servers. Limiting the number of concurrent connections manages performance. Type or select the maximum number of connections that are allowed to the database at one time. That number must be greater than or equal to the number of threads that are running in the Event Processor. See Configuring the Event processor service.
Database Failure Policy	Select the failover option. Available options are Fail over, Fail back, and Disable Backup. For more information about failover options, see SQL database DSA failover modes.

Table 2. Primary source settings for MS-SQL Server data source window
Window element	Description
Host Name	Type the host name. The default value is `localhost`.
Port	Select a port number. The default number is `1433`.
Database	Type the name of the database to connect to. Note: You can specify additional JDBC connection properties after the database name. Each property should be delimited by a semicolon (`;`). For example, to encrypt the MS-SQL database connection, you could specify the following value: `MSDB;encrypt=true;trustServerCertificate=true`
Test Connection	Click to test the connection to the host to ensure that you entered the correct information. Success or failure is reported in a message box. If the host is not available at the time you create the data source, you can test it later. To test the connection at any time, from the data source list, right-click the data source and select Test Connections from the list of options. Important: If you see an error message stating that the data source cannot establish a connection to a database because a JDBC driver was not found, it means that a required JDBC driver is missing in the shared library directory. To fix this, place a licensed JDBC driver in the shared library directory and restart the server. For more information see, the SQL database DSAs chapter in the Netcool/Impact DSA Reference Guide.

Table 3. Backup source settings for MS-SQL Server data source window
Window element	Description
Host Name	Type the host name. The default value is `localhost`.
Port	Select a port number. The default value is `1433`.
Database	Type the name of the database to connect to. Note: You can specify additional JDBC connection properties after the database name. Each property should be delimited by a semicolon (`;`). For example, to encrypt the MS-SQL database connection, you could specify the following value: `MSDB;encrypt=true;trustServerCertificate=true`
Test Connection	Click to test the connection to the host to ensure that you entered the correct information. Success or failure is reported in a message box. If the host is not available at the time you create the data source, you can test it later. To test the connection at any time, from the data source list, right-click the data source and select Test Connections from the list of options.

Note:

Integrated security is supported by JDBC on Windows operating system only, by adding the integratedSecurity=true option (as below). If this option is used, it looks for the sqljdb_auth.dll file in the library path.

To use Windows authentication, add ;integratedSecurity=true to the database name using the GUI.

After making this change, the relevant .ds file in the impact\etc directory will look like this:

<Datasource>.MS-SQLServer.PRIMARYDATABASE=database;integeratedSecurity\=true