We were unable to connect to the IIQ console and received the following error ct to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;"

IdentityIQ (IIQ) IIQ Discussion and Questions
1

while trying to install identityiq IIQ, when we run the IIQ ConsolE on the CMD i.e IIQ console started from path: apache-tomcat-9.0.2/webapps/identityiq/WEB-INF/bin.

We unable to connect with IIQ console.We were recieveing this error-“Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;”.

Full error messages: C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq\WEB-INF\bin>iiq console adding exports for Java 17iiq.hostname : w8881-console
2024-10-29T10:42:28,583 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.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;
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.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;

We confirm the DB HOSTNAME WHICH was w8882 which was correct, we confirm that we can login to the three identityiq database account on the iiq properties:

identityiq
identityiqPlugin
identityiqah

We also installed Microsoft SQL Server Management Studio on the SailPoint server to check connectivity, username, and password. We could log in successfully, but the IIQ console still failed to connect to the database.

We tried different URL formats in the iiq.properties file:

OLD one: sqlserver://w8882\MSSQLSERVER:1479

TRY 1: sqlserver://w8882,1479\MSSQLSERVER:1479

TRY 2: sqlserver://w8882,1479:1479

TRY 3: sqlserver://w8882,1479

Despite these attempts, we still couldn’t connect to the IIQ console.

we tried default port number but the same error. we could login and connect to the DB.

Please any help.

2

This is ultimately a database error, and not a very useful one. The rest is all noise except for: Unable to connect to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;”.

I would check that either your password is encrypted with a different keystore than your iiq.properties is pointing to, or else the password is incorrect altogether.

Make sure that the connection options (encryption and so forth) match whatever you’re using in SSMS, as well. You may need to set some additional connection properties after “databaseName”.

1 Like
3

Thank you for your response. We tried it, but we still have the error.

4

@drosenbauer yes, you are right,-- Resolution: The database encryption setting was blocking the iiq.properties from checking the IdentityIQ database. We modified the three IdentityIQ database accounts in the iiq.properties file by adding Encrypt=False; . Here is the updated line:

jdbc:sqlserver://w8882:1479;databaseName=identityiq;Encrypt=False;