Issues connecting to Azure IAM DB during configuration of new install - ERROR: Failed to obtain JDBC connection

Products

• Service Virtualization

Issue/Introduction

When configuring IAM to connect to an Azure Database through Active Directory, getting this error when starting the IAM service:

2025-05-30 15:27:53,426 INFO  [com.arjuna.ats.jbossatx] (main) ARJUNA032014: Stopping transaction recovery manager

2025-05-30 15:27:53,452 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (production) mode

2025-05-30 15:27:53,452 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to obtain JDBC connection

2025-05-30 15:27:53,452 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Acquisition timeout while waiting for new connection

2025-05-30 15:27:53,452 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) For more details run the same command passing the '--verbose' option. Also you can use '--help' to see the details about the usage of the particular command.

 

NOTE: Database connection to Azure is SQL Server/SQLMI (SQL Managed Instance)

Environment

All supported DevTest Environments.

- Database Server: Microsoft SQL Server
- Database Server Version: 12.00.2000
- Database Driver Name: Microsoft JDBC Driver 8.2 for SQL Server
- Database Driver Version: 8.2.0.0

Cause

Missing needed JDBC SQL Server driver jar in folder: {IAM_HOME}\providers

Resolution

As a workaround copy {DEVTEST_HOME}\lib\shared\mssql-jdbc-8.2.0.jre8.jar to {IAM_HOME}\providers and restart IAM service.

NOTE:  Depending on the version of DevTest you are running, the SQL Server JDBC jar delivered may be different.  This example is for DevTest 10.8.1.

Additional Information: DevTest configuration for connecting to Azure SQL Server