Unable to connect MSSQL DB via AD credentials

[nprajapati (Nitin Prajapati)]

Which IIQ version are you inquiring about?

8.4

Please share any images or screenshots, if relevant.

Error:

iiq console
Setting iiq.hostname to WIN-XXXXXX-console
2022-03-01T07:30:17,632 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.AbstractMethodError
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.AbstractMethodError

Share all details about your problem, including any error messages you may have received.

WE are trying to connect MSSQL via AD creds and IIQ is installed on linux server.
I’m using jtds 1.3.1 jar file which is present in WEB-INF\lib
Able to open DB with AD creds via SMS tool.
Also connectivity and remaining require permission are in place.

[officialamitguptaa (Amit Gupta)]

@nprajapati -

Your issue seems related to using the jTDS driver to connect MSSQL via Active Directory (AD) credentials in a SailPoint IdentityIQ (IIQ) installation on a Linux server. The key error:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.AbstractMethodError

Troubleshooting Steps:

1. Check jTDS Compatibility

   • jTDS 1.3.1 does not support AD authentication with integratedSecurity=true on Linux.
   • The jTDS driver depends on NTLM authentication, which is not fully supported in Linux environments for AD authentication.

2. Switch to Microsoft JDBC Driver
   Instead of jTDS, use the Microsoft JDBC Driver for SQL Server (mssql-jdbc-*.jar). Update the dataSource.url:

   dataSource.url=jdbc:sqlserver://<server>:1435;databaseName=identityiq;authentication=ActiveDirectoryIntegrated
   dataSource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
   

   Steps to switch:

   • Download the latest Microsoft JDBC Driver from:
     https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server
   • Place it in WEB-INF/lib
   • Update the iiq.properties file with the correct driver class and URL.

3. Verify Kerberos Authentication (if needed)

   • If your environment requires Kerberos, you may need to configure a krb5.conf file and set up a keytab.

4. Test Connectivity

   • Use a standalone JDBC test script with the Microsoft driver to confirm connectivity before restarting IIQ.

Next Steps:

• Try switching to the Microsoft SQL Server JDBC driver and let me know if you encounter issues.
• If you must use jTDS, consider using an alternative method like Kerberos authentication instead of integratedSecurity=true.

Hope this helps.

[nprajapati (Nitin Prajapati)]

I have remove the jtds drivers and using jdbc drivers with url string

jdbc:sqlserver://:1435;integratedSecurity=true;authenticationScheme=javaKerberos;

Now i’m getting below error
org.springframework.beans.factory.BeanCreationException: 559 Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Invalid object name ‘spt_database_version’.