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.

Do you need a powerful database designer for Azure SQL?

Try DbSchema Learn More

How to Create and Connect to Azure SQL Database


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.

Create Database Networking

Get the JDBC URL

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

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.

Connection Dialog

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

User Name


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:

Connect Exception


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

Setup Firewall

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.