com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi Everyone,

Did any one tried Windows based MSSqlserver authentication using JDBC Connector type? We were trying to use Windows based authentication tried to attached two different drivers Mssqljdbc9.2.0 and Mssqljdbc9.4.0 jar files in both cases we receiving below exception

Any pointer please.

sailpoint.connector.JDBCConnector.getConnection(JDBCConnector.java:2196)\n\t… 12 more\nCaused by: sailpoint.tools.GeneralException: Failure trying to get a pooled connection to [jdbc:sqlserver://jdbcserver:port;databaseName:dbname;integratedSecurity=true] com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:\n\tat sailpoint.connector.util.DBCPPoolVersion2.getPooledConnection(DBCPPoolVersion2.java:176)\n\tat sailpoint.connector.util.JDBCUtilFactory.getJDBCImpl(JDBCUtilFactory.java:24)\n\tat sailpoint.connector.util.JDBCUtil.getConnection(JDBCUtil.java:287)\n\t… 13 more\nCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3422)\n\tat com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:72)\n\tat

Thank you!
Sailaja

2

@colin_mckibben Any Pointers please?

3

@sailajaprathi I just spoke with professional services, and they said that integrated windows auth for JDBC sources is not supported. This is because the connection is made from the virtual appliance (VA), and the VA is not a part of the domain. Only database authentication is supported for JDBC connectors.