Configuration Parameters

When you install CDP for MSSQL, a properties file named CDP_MSSQLServer.properties is loaded at installed location. The properties contains the parameters that helps you configure the CDP client.

Important Notes

1. The values in the properties file are case-sensitive. yes is not YES, or Yes. tcp is not TCP or Tcp. Follow the example of the default properties file.

2. You can comment-out values using #. You may want to use comments to save settings when troubleshooting.

3. When editing parameters that use time values, you can use the following abbreviations:

   a. ms - Milliseconds. For example, 4500ms for 4.5 seconds.

   b. s - Seconds. For example, 30s for 30 seconds.

   c. m- Minutes. For example, 5m for 5 minutes.

   d. h - Hours. For example, 10h for 10 hours.

   e. d - Days. For example, 2d for 2 days.

   Note

   If you do not include an abbreviation, the default time unit is used.

4. If you modify the value of log level in the properties file after installing the CDP for SQL Server, you can use the stored procedure ing_reload_propertyfile_value to clear existing log level value and reload new values in the properties file.

   For example:

   • If any connection already exists, then the stored procedure clears the old value of the Log_Level parameter only and reloads its new value.

   • If no connection exists, then the stored procedure reloads the entire updated properties file with new parameter values.

The CDP configuration parameters are classified into.

• Network Configuration Parameters

• Connection Configuration Parameters

• Local Encryption Configuration Parameters

• Logging Parameters

• SSL Configuration Parameters

• SQL Server Specific Configuration Parameters