You must have Secure communication and you need to know a way to setup Database collection over security communication.
Supportability Comment: Configuring Secure Communication over SSL with Microsoft SQL databases with Microsoft SQL JDBC Drivers has been tested and is supported. This documentation is provided as a courtesy. If any assistance is needed on the side of configuring Microsoft SQL, you must contact Microsoft.
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 SSL for an SQL Server.
See “To configure SSL for the SQL Server”.
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
Start SQL Server Configuration Manager.
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.
The logon packet is always encrypted.
Set the ForceEncryption option to Yes.
ForceEncryption encrypts all client/server communication and clients that cannot support encryption are denied access.
Restart the SQL Server.
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 left pane, select the appropriate configuration.
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: