Azure SQL jdbc connection String

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi, Everyone,

Has anyone configured JDBC connection connecting to SQL Server in Azure? I always got timeout and the error message stated “This driver is not configured for integrated authentication”, but my authentication type is “Azure ActiveDirectory Password”.
The following is the jdbc connection string, can anyone shield lights what the issue could it be?

jdbc:sqlserver://myServer; databseName=myDB;encrypt=true;integratedSecurity=true;hostNameInCertificate=*.database.windows.net;ActiveDirectoryPassword =true

Thank you for your help

2

Welcome to the developer community John.

The error message suggests the issue is with the driver you are using, not the connection string. Can you please share what driver and version you are using in the JDBC connector? Also, have you tried using that driver locally on your machine to connect to the Azure DB?

3

Hi John,

I believe you are using JDBC driver. Currently, JDBC driver doesn’t support Integrated authentication, it only supports local SQL authentication. See below IDN doco:
https://documentation.sailpoint.com/connectors/jdbc/help/integrating_jdbc/account_connection_settings.html

4

Thank you for comfirming, Gaurav, yeah, I read a post in community, and notice there is an enhance request.

5

Colin,
I realized it is not supported at this time. See Gaurav’s message below.

6

Hey @JohnS01 , You can keep the local DB user credentials in PAM tools like CyberArk until SailPoint releases Integrated authentication enhancement, which will help you get rid of this process, but it will meanwhile keep things secure.

7

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