You are trying to use JDBC driver version 2.0 sqljdbc.jar file with a SSIM Database Collector but it is not on the SSIM 4.8 server

Products

• Security Information Manager

Issue/Introduction

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.

 

 

Resolution

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:

1. Login as db2admin

2. su - to root user

3. cd to /opt/Symantec/simserver/collectors/drivers/sqljdbc_4.0/enu/   

4. Type ln -s /opt/Symantec/simserver/collectors/drivers/sqljdbc_4.0/enu/sqljdbc4.jar sqljdbc.jar

5. chown -h sesuser:ses sqljdbc.jar

6. Restart the Agent using agentmgmt.sh script in/opt/Symantec/sesa/Agent and choosing option 11