You are trying to use the JDBC driver version 2.0 sqljdbc.jar file with a SSIM Database Collector but it is not on the SSIM 4.8 server. It was on the SSIM 4.7 servers
When you configure the Sensor you see the following error in the logs for the collector:
ERROR 2013-02-15 06:03:28,123 Collectors.3137.wGroup.[workinggroup0].Sensor.[Sensor_0] com.symantec.management.util.TimerThread com.symantec.cas.ucf.sensors.InitSensorException: Cannot find JDBC driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver". It is possible an incorrect "JDBC Drivers Directory" was specified.
ERROR 2013-02-15 06:03:28,123 Collectors.3137.wGroup.[workinggroup0] com.symantec.management.util.TimerThread Error while initializing the sensor Sensor 0. Cannot find JDBC driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver". It is possible an incorrect "JDBC Drivers Directory" was specified.
1.The collector will work with the sqljdbc 4.0 JDBC drivers. You need to create a symbolic link to the driver following the steps below:
Login as db2admin
su - to root user
cd to /opt/Symantec/simserver/collectors/drivers/sqljdbc_4.0/enu/
Type ln -s /opt/Symantec/simserver/collectors/drivers/sqljdbc_4.0/enu/sqljdbc4.jar sqljdbc.jar
chown -h sesuser:ses sqljdbc.jar
Restart the Agent using agentmgmt.sh script in/opt/Symantec/sesa/Agent and choosing option 11
Imported Document ID: TECH202941
Subscribing will provide email updates when this Article is updated. Login is required.