We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

What operating system does your server use?

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

Anamika,

It has been a while since I used JDBC with SQL server, but I think you need to check the configuration of your SQL Server instance.

 From what I remember, you must specify which authentication methods are valid for your SQL Server instance. The next thing to check is the long list of properties the JDBC driver supports.

It sounds like you need to configure SQL Server or the JDBC driver to support integrated authentication.

Wayne

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

Hi,

For a JDBC Pool why not using the out-of-the-box DataDirect Driver.

For JDBC Adapter connection, try to verify the following:

• For Windows 32 or Windows 64, copy the appropriate library (sqljdbc_auth.dll or mssql-jdbc_auth-x.x.x.xxx.dll) to Integration Server_directory\instances\instance_name\lib directory.

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

------------------------------
Anamika Pramanick
------------------------------

Anamika, there are a few things we need to check, assuming that you SQL instance is installed and configured against Active Directory and is an on-premise database. PaaS and SQL MI are a little challenging to use Integrated Auth.
1. Your IS instance is running on Windows Server and under an Active Directory Service Account (SA)

2. The SA has been granted at least db_reader permissions to the DB

3. You have set the property integratedSecurity=true and also you should have set certificate properties. Similar to encrypt=true;trustServerCertificate=true;loginTimeout=60;integratedSecurity=true;

4. You may add multiSubnetFailover=true; if you are connecting to an Availability Group

5. You have the mssql-jdbc_auth-*.dll installed in the correct folder

------------------------------
Jerome Green

Original Message:
Sent: Wed August 20, 2025 01:42 AM
From: Anamika Pramanick
Subject: JDBC Connection Issue using windows authentication

We are trying to use windows authentication in JDBC connection pool and adapter. The user in windows authentication looks similar to "DTCMUSER\DUSR". When we try to implement we receive error saying : "

[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.sqlserver.jdbc.SQLServerDataSource".This driver is not configured for integrated authenticatio

"

------------------------------
Anamika Pramanick
------------------------------