How to Connect to Azure SQL

Connecting to the database will require to enter the host, port, database user and password as explained in the Connection Dialog.

Create a Database in Azure

Create an free account on https://manage.windowsazure.com/ On the dashboard choose to create an SQL Database. During creation make the database public accessible in the networking tab.

How to create an AzureSQL database How to configure AzureSQL Network Settings

Get the JDBC URL

Then from the menu you can choose the JDBC connection string:

Get the AzureSQL JDBC URL connection string

Enter the JDBC URL in DbSchema

Use the JDBC connection string in the DbSchema Connection Dialog / JDBC URL tab. In the connection string replace the '{password}' with the password you have choose when creating the database user.

Copy the JDBC URL in the DbSchema connection dialog

In the 'Compose URL' panel enter the same username and password :

Enter the AzureSQL username and password

Make sure the Database is public accessible

If the database was not set public when created, you may need to add a firewall rule to allow remote access. In this message you can see your client IP:

Setup rule allow connections through firewall to AzureSQL


Then from the top menu create a firewall rule for it.

Setup Windows Firewall for AzureSQL

Connect using Active Directory Security

Connections using Active Directory security are allowed in two modes:
  1. Using Username and Password In the connection dialog choose the 'Active Directory Authentication with User and Password' connection method.
  2. Using Active Directory Integrated Security To use this method please install first this library (copy the link on your system browser): https://www.microsoft.com/en-us/download/details.aspx?id=48742 After this choose the 'Active Directory Integrated' connection method in the Connection combo.