Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Connect to a SQL Azure database

Connecting SQList to a SQL Azure database is not very different than connecting it to a SQL Server on premise, there are only a couple of of small details to be aware of.

Note that in this document we will connect to an SQL Azure database that uses SQL authentication. If you want to use Azure AD authentication, please see this article:

Once the SQL Azure database has been configured, you will need to retrieve the full connection detail. A quick way to do that it to select the option Show database connection strings as shown in these screenshots:

Image Placeholder

Image Placeholder

In SQList Manager, you can configure the connection to the database either by entering the individual details (server name and instance, database name, and credentials) or by entering the connection string directly.

Note that the server name/instance must be in the format:

Image Placeholder   Image Placeholder

Once entered the details, click the Test connection to ensure the connection is successful. You should get a message like this:

If you get a failed connection message like the one shown below, the probable reason is that you have not allowed the IP of the machine running SQList to go through the Azure SQL Server's firewall:

Image Placeholder

To allow access, from the Overview of the Azure SQL database click the Server name link and then the Show firewall settings link:

Image Placeholder

Image Placeholder

In the firewall setting screen, add a rule by entering these values:

  • Rule name: enter a name to identify the rule (e.g. "AllowSQListIP");
  • Start IP: enter the public IP of the machine running SQList - this is the IP shown in the SQList error message;
  • End IP: enter the same IP as above.

Image Placeholder

Ensure that you save the settings. Try the connection again in SQList Manager and it should be successful.

If you have any questions about this article or need any assistance please contact us at support@axiowork.com