If you use Microsoft SQL Server 2005 database with the Microsoft SQL Server 2005 JDBC driver 1.2, you can configure an SSL connection.
Note:
Microsoft SQL Server 2005 JDBC driver 1.1 or earlier does not support SSL.
In order to configure an SSL connection, you must complete the following procedures:
Configure the sensor properties for an encrypted protocol.
See “To configure the sensor properties for an encrypted protocol”.
See Installing collectors that use a database sensor.
To configure SSL for the SQL Server
Expand SQL Server Network Configuration, right-click the protocols for the server that you want, and then click Properties.
On the Certificate tab, select the certificate that you want to use to protect your connection.
Self-signed certificates are supported but not recommended because they do not provide adequate security.
On the Flags tab, view or specify the protocol encryption option.
Set the ForceEncryption option to Yes.
ForceEncryption encrypts all client/server communication and clients that cannot support encryption are denied access.
To configure the sensor properties for an encrypted protocol
In the Information Manager console, in the left pane, click System.
Select the Product Configurations tab, and then expand the tree until you see the collector name.
In the right pane, on the sensor tab, under the list of sensors, click the sensor.
In the Database URL field, add the following property string at the end of the URL:
jdbc:sqlserver://192.168.19.40:1433;DatabaseName=database_name; encrypt=true
If you are using a self-signed certificate, add the following property string at the end of the URL:
jdbc:sqlserver://192.168.19.40:1433;DatabaseName=database_name; encrypt=true;trustServerCertificate=true
In the left pane, right-click the appropriate configuration, and then click Distribute.
When you are prompted to distribute the configuration, click Yes.