This article requires DbVisualizer 12.0 and later versions.
When connecting to Azure SQL Database using you will need to do the following:
- Download the active directory jar files
- Edit the driver definition in Tools->Driver Manager
- Change/add the driver property: authentication and set the value to ActiveDirectoryPassword for your Azure database connection
You will need to download and add all the jars specified by the maven artifact adal4j including all its dependencies. The full id of this artifact is specified by the maven dependency specification below. It's recommended to use the most recent version.
<dependency> <groupId>com.microsoft.azure</groupId> <artifactId>adal4j</artifactId> <version>1.6.6</version> </dependency>
Tip: There exists online resources that helps in the process of downloading all dependencies. One example is the Online Maven download tool.
Edit the Azure driver definition
Once all jar files are downloaded open DbVisualizer and the Tools->Driver Manager. Select the Azure driver and add all jar files just downloaded. Close the Driver Manager.
Adjust the Azure database connection
Open the Connection tab for the Azure database connection and set the Authentication Method to ActiveDirectoryPassword. Now try Connect to verify.
Read more on Azure and Active Directory authentication at Microsoft: https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver15