When We tried to connect to Azure SQL Database through Hikari Data Source in Mulesoft. When we tried to connect through Microsoft SQL Server Connection , its working fine with out issues. But when we tried to connect through Hikari Data source , We are getting the below Error
org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source
org.mule.runtime.api.connection.ConnectionException: Could not obtain connection from data source
Caused by: org.mule.extension.db.api.exception.connection.ConnectionCreationException: Could not obtain connection from data source
Caused by: java.sql.SQLException: Failed to authenticate the user XXXXXXXX in Active Directory (Authentication=ActiveDirectoryPassword). AADSTS50034: The user account “EUII Hidden” does not exist in the directory. To sign into this application, the account must be added to the directory. Trace ID: Correlation ID: Timestamp: 2024-06-01 18:04:26Z
Caused by: java.sql.SQLException: Failed to authenticate the user XXXXXXXX in Active Directory (Authentication=ActiveDirectoryPassword). AADSTS50034: The user account “EUII Hidden” does not exist in the directory. To sign into this application, the account must be added to the directory. Trace ID: Correlation ID: Timestamp: 2024-06-01 18:04:26Z
We have added all of the below dependencies in pom.xml . Pls do let us if we have to add any other dependencies.
<dependency>
<groupId>com.microsoft.azure</groupId>
<artifactId>msal4j</artifactId>
<version>1.11.3</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>11.1.0.jre8-preview</version>
</dependency>
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>4.0.3</version>
</dependency>