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.

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 / Edit 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