Error - Cannot load JDBC driver class encountered when deploying ARCOT UDS (Arcot User Data Service)

Products

• CA Advanced Authentication
• CA Strong Authentication

Issue/Introduction

Deployment of ARCOT UDS via an application server fails if the sqljdbc.jar is not found in the <APPLICATION_SERVER_HOME>\lib. Note if JRE version greater or equal to 1.6 sqljdbc4.jar may be required in the afore mentioned directory. The stack trace that is generated when this error is encountered is as follows:

==================== Stack Trace related to the issue =======================================================
[ERROR] Internal error: Unable to list common configuration '
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

========================= End of Stack Trace =======================================================

Environment

Release:
Component: WEBFRT

Resolution

Copy the sqljdbc.jar to the <APPLICATION_SEVERVER_HOME>\lib. Restart the application server to re-deploy Arcot UDS.