IDM database (mssql) via integrated authentication ( Windows Authentication)

Products

• CA Identity Suite

Issue/Introduction

Getting the following error while starting IDM

 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm
..........
    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624)
    ... 28 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication

Environment

Identity Manager 14.5 standalone with MSSQL 2019

Cause

Not configured Jboss 7.4 for integratedSecurity properly

Resolution

1. Download the compatible version of the JDBC driver with MSSQL from 

https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

2. Get mssql-jdbc_auth-11.2.3.x64.dll.

2. Rename it to mssql-jdbc_auth-11.2.0.x64.dll.

3. Move it to D:\com\microsoft\sqlserver\jdbc\main\auth\x64 or a relative path

4. In standalone.conf.bat, the config file has:

rem ------ Define com library path ------
set "JAVA_OPTS=%JAVA_OPTS% -Djava.library.path=D:\com\microsoft\sqlserver\jdbc\main\auth\x64"

5. Restarted IDM, and it seems to work now.

Additional Information

For the Identity Manager on Virtual Appliance, it does not support Windows Authentication for connecting to a Microsoft SQL Server database.  Please refer to the KB

https://knowledge.broadcom.com/external/article/405242