Unable to connect MS SQL

IdentityIQ (IIQ) IIQ Discussion and Questions
1

I have install IIQ and MSSQL but unable to connect it I have done the configuration in iiq.properties both are install in same machine i.e windows. Below is the error.

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://localhost:1433;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://localhost:1433;databaseName=identityiq;
iiq.properties (16.9 KB)

2

Hi @nitindpraj

Both the username and password are commented out.

#dataSource.username=identityiq
#dataSource.password=

2 Likes
3

Hi @nitindpraj

Welcome to sailpoint community. Can you please confirm if this issue is occurring in ISC or IIQ server ?

Thank You.
Regards
vikas

1 Like
4

I’ve removed the comment and made the username=sa and password=****
but still not working same error

5

Its IIQ server and I’m trying to connect to MSSQL

6

Hi @nitindpraj

Check if the SQL service is running on port 1433 with telnet.

telnet localhost 1433

1 Like
7

Hi @nitindpraj,

I think the query is around IIQ although the functionality is similar b/w both IIQ and ISC. But I think you will get more engagement and support if your query is correctly tagged to IIQ queries (
IdentityIQ (IIQ)IIQ Discussion and Questions

identityiq

Thanks,
Aman

2 Likes
8

Are you able to connect to IIQ console ?

9

I’m able to telnet localhost and 1433. Also named pipe and TCP/IP are enabled. I’m getting above error while running iiq console command

10

Thanks for this, it actually works

11

It got resolved for me it was encrypt=true trustservercertificate=true entry in iiq properties

2 Likes
12

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.