Microsoft SQL Server Connector Connection Issue

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi Team,

We configured Microsoft SQL Server Connector in our Identitynow tenant and imported the proper jre files as per sailpoint documentation. Our firewall access is also allow, however when we hit on test connection we get the following error message: We are using a SQL Authentication to connect.

Error Received:

[ ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. “encrypt” property is set to “true” and “trustServerCertificate” property is set to “false” but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

image
image757×411 12 KB

2

Check the JDBC query , if the encrypt variable is set to true.

If you wanna use SSL , you need to import the Certificate of the DB to tha keystore of the VA.

Best!

3

@ipobeidi this the jdbc query that i’m using.
jdbc:sqlserver://dummy:1433;databaseName=testdb;

4

changed it to this

jdbc:sqlserver://dummy:1433;databaseName=testdb;encrypted=false;trustServerCertificate=true;

1 Like
5

thanks that did the trick.