# We were unable to connect to the IIQ console and received the following error ct to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;" **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq\ **Created:** [October 29, 2024, 1:18pm UTC](https://developer.sailpoint.com/discuss/t/we-were-unable-to-connect-to-the-iiq-console-and-received-the-following-error-ct-to-jdbc-w8882-1479-databasename-identityiq/87289 "2024-10-29T13:18:13Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![sulubayo](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@sulubayo](https://developer.sailpoint.com/discuss/u/sulubayo)\ **Post date:** [October 29, 2024, 1:18pm UTC](https://developer.sailpoint.com/discuss/t/we-were-unable-to-connect-to-the-iiq-console-and-received-the-following-error-ct-to-jdbc-w8882-1479-databasename-identityiq/87289/1 "2024-10-29T13:18:13Z")
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. ---
**Author:** ![drosenbauer](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/drosenbauer/32/3381_2.png) [@drosenbauer](https://developer.sailpoint.com/discuss/u/drosenbauer)\ **Post date:** [October 29, 2024, 5:14pm UTC](https://developer.sailpoint.com/discuss/t/we-were-unable-to-connect-to-the-iiq-console-and-received-the-following-error-ct-to-jdbc-w8882-1479-databasename-identityiq/87289/2 "2024-10-29T17:14:29Z")
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”. ---
**Author:** ![sulubayo](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@sulubayo](https://developer.sailpoint.com/discuss/u/sulubayo)\ **Post date:** [October 30, 2024, 8:17am UTC](https://developer.sailpoint.com/discuss/t/we-were-unable-to-connect-to-the-iiq-console-and-received-the-following-error-ct-to-jdbc-w8882-1479-databasename-identityiq/87289/3 "2024-10-30T08:17:35Z")
Thank you for your response. We tried it, but we still have the error. ---
**Author:** ![sulubayo](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@sulubayo](https://developer.sailpoint.com/discuss/u/sulubayo)\ **Post date:** [October 31, 2024, 6:43pm UTC](https://developer.sailpoint.com/discuss/t/we-were-unable-to-connect-to-the-iiq-console-and-received-the-following-error-ct-to-jdbc-w8882-1479-databasename-identityiq/87289/4 "2024-10-31T18:43:33Z")
@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; ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [December 30, 2024, 6:43pm UTC](https://developer.sailpoint.com/discuss/t/we-were-unable-to-connect-to-the-iiq-console-and-received-the-following-error-ct-to-jdbc-w8882-1479-databasename-identityiq/87289/5 "2024-12-30T18:43:40Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.