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:
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:
tcp:<server_name>.database.windows.net,1433
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:
To allow access, from the Overview of the Azure SQL database click the Server name link and then the Show firewall settings link:
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.
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