Running a database job gives the error message: java.lang.ClassNotFoundException: com.microsoft.sqls

Document ID : KB000089423
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Running a database job gives the error message: java.lang.ClassNotFoundException: com.microsoft.sqls
Resolution:
Detailed Description and Symptoms

Attempting to run a job on a database agent for MSSQL aborts and returns the error messages in the agent log:

U2012031 The database driver returned the following error message:
          java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
U2004025 Job-script execution was aborted.

 

PLEASE NOTE: These messages only occur if the "Agent log" option is selected in the SQL tab of the job.


Investigation

?This message usually appears when the incorrect jdbc driver (or no jdbc driver) is in the jdbc directory for the agent.


Solution

To resolve this error message, be sure that the correct jdbc driver for the agent is in the \bin\jdbc\ directory for the ?database agent.  JDBC drivers can be found from the database manufacturer.  The Automic documentation has a place to start.  This can be found under Administration Guide, Installation, New Installation, Installation Procedure, Installing the Agents, Installing the Agent for Databases, Installing the Agent for Database Jobs and Events, step 3.