Help with service principal authentication Azure SQL
Hi! Im struggling with a service principal connection to Azure SQL database. I have the following JDBC URL: jdbc:sqlserver://xxxx.datawarehouse.pbidedicated.windows.net:1433;database=Postgres_Mirror;user=xxx;password=xxx;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.datawarehouse.pbidedicated.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword
I have used the DB connector with the following configuration:
But I keep getting the following error: Execute failed: Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication.
I looked trough the forums, and found that I need to install the MSAL4J prequisites, but I cannot find from anywhere how. Any help with this is much appriciated :slight_smile: