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?

OS of IS server is Linux. This issue was resolved by placing proper .dll files in IS and making changes in JDBC adapter config settings.

We also implemented the same in MWS using CCE

Thanks for your support

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

Thanks Wayne!! It worked.

Hi,

For a JDBC Pool why not using the DataDirect out-of-the-box 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.

https://www.ibm.com/docs/en/webmethods-integration/all?topic=properties-microsoft-sql 

Good luck

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.

This issue was resolved by placing proper .dll files in IS and making changes in JDBC adapter config settings.

We also implemented the same in MWS using CCE.

Thanks a lot for your input

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
------------------------------

Thanks Jerome !!

This issue was resolved by placing proper .dll files in IS and making changes in JDBC adapter config settings.

We also implemented the same in MWS using CCE