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 …

Hi @nitindpraj Both the username and password are commented out. #dataSource.username=identityiq #dataSource.password=

Hi @nitindpraj Welcome to sailpoint community. Can you please confirm if this issue is occurring in ISC or IIQ server ? Thank You. Regards vikas

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

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

Hi @nitindpraj Check if the SQL service is running on port 1433 with telnet. telnet localhost 1433

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

Are you able to connect to IIQ console ?

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

Thanks for this, it actually works

Unable to connect MS SQL

IdentityIQ (IIQ) IIQ Discussion and Questions

nitindpraj (Nitin Prajapati) July 22, 2024, 11:39am 11

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

2 Likes

Error while opening IIQ console

Topic		Replies	Views
We were unable to connect to the IIQ console and received the following error ct to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;" IIQ Discussion and Questions identityiq	4	301	December 30, 2024
Install on MS SqlServer error IIQ Discussion and Questions identityiq	20	349	October 5, 2024
Error while opening IIQ console IIQ Discussion and Questions workflows , apis , rules , identityiq , provisioning , connectors	7	97	February 21, 2026
Configure Identityiq with Microsoft SQL(MSSQL) DB using Windows Domain account IIQ Discussion and Questions identityiq	4	130	January 3, 2026
Unable to connect MSSQL DB via AD credentials IIQ Discussion and Questions identityiq	3	175	April 6, 2025

Unable to connect MS SQL

Related topics