Exception while loading connector class java.lang.ClassNotFoundException: sailpoint.connector.MSAzureSQLDatabaseConnector

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

when i try to create a Microsoft azure connector , i am getting this error “Exception while loading connector class java.lang.ClassNotFoundException: sailpoint.connector.MSAzureSQLDatabaseConnector from [Module ““deployment.SAILPOINT-identityiq.war”” from Service Module Loader]”
while do test connection.Teh efault schema, provisionig policy are also not even getting loaded.

2

Hi @ksuneeth85
Please check this out: Integrating SailPoint with Microsoft Azure SQL Database

In addition to the documentation, the error ClassNotFoundException: sailpoint.connector.MSAzureSQLDatabaseConnector typically indicates a missing connector JAR issue. Please check the following:

Verify that connector-bundle-misc-8.5p1.jar is present in: iiq\WEB-INF\lib\

Also make sure the Microsoft JDBC Driver JAR is present in the same location: mssql-jdbc-12.x.x.jre11.jar

3

Hi @ksuneeth85

Please verify if the corresponding JAR file is loaded in the lib folder of IIQ Installation path.

4

@ksuneeth85 Please check the IIQ connector bundle jar if it is available inside WEB-INF/lib-connectors folder. IIQ using the jars available in this folder for connector related modules. And generic drivers, in lib folder like mssql-jdbc-13.4.0.jre11.jar. Also make sure it is compatible with the java version you have, mssql-jdbc-13.4.0.jre11.jar → it should work with Java 11 & 17.

In case it is available in both lib-connectors and lib folder, you ned to delete the one available in lib folder.

Note: Found a fix?Help the community by marking the comment as solution. Feel free to react(:heart:,:+1:, etc.)with an emoji to show your appreciation or message me directly if your problem requires a deeper dive.

5

after i placed onnector-bundle-misc.jar , then it worked. Thanks Sai. One query , as per SailPoint document , they are telling to user -mssql-jdbc-8.4.1.jre8.do in need to use new version or will that work

6

Here is what I recommend:If you are using Java 8 - stick with mssql-jdbc-8.4.1.jre8.jar as mentioned in the documentation

If you are using Java 11 or higher - use mssql-jdbc-12.x.x.jre11.jar (latest stable version)

if you are using IIQ 8.5 running on Java 17 the newer version mssql-jdbc-12.x.x.jre11.jar is recommended for better compatibility and security fixes.