FAQ: Questions about Database Connector Connecting to Azure SQL Server DB

What JDBC driver should I use in my Mule application to connect to Azure SQL Server?

How to form up the JDBC URL for accessing Azure SQL server?

1. In Azure console, go to the Azure SQL Server in which the required database is present and you want to connect.
2. Go to the Azure SQL Database in that server.
3. Go to the Connection Strings row in the database.
4. Go to the JDBC Column of the connection strings.
5. Here you can find the connection strings for accessing Azure SQL server.
6. And choose the required authentication method connection string you want to use.
7. What version of Microsoft SQL JDBC driver is needed for connecting to Azure SQL Server

The examples of JDBC connection string for Azure SQL server

• JDBC (SQL Authentication) :
  
  jdbc:sqlserver://{tenent}.database.windows.net:1433;database={db name};user={user name}@{tenent};password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
   
• JDBC (Active Directory password Authentication) :
  
  jdbc:sqlserver://{tenent}.database.windows.net:1433;database={db name};user={your_username_here};password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword
   
• JDBC (Active Directory Integrated Authentication) :
  
  jdbc:sqlserver://{tenent}.database.windows.net:1433;database={db name};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;Authentication=ActiveDirectoryIntegrated
   

Which of the 3 URLs above is suitable for a Mule application running on a standalone Linux without Active Directory domain membership, such as a CloudHub worker?

Only the one with JDBC (SQL Authentication) is suitable for CloudHub worker. The other 2 needs the client machine to get AD domain membership.

Can my CloudHub app connect to Azure SQL Server using Azure AD Service Principal Accounts?

No, Only the one with JDBC (SQL Authentication) is suitable for CloudHub worker.