Home > Documentation > Miscellaneous

How to Connect to Azure SQL

This article described how to connect to Azure SQL from Intelligent Converters products. First, you should make sure that your IP address in the list of allowed IPs:

1. open the Dashboard and click on the server you want to configure

2. click on "Show firewall settings" link

3. click on "Add client IP" link and make sure that the control "Allow access to Azure services" is ON

Now it's time to get the name of Azure Server:

go back to Dashboard and click on database name you want to use (it is "test0425" on the 1st screenshot above)
you will see window like on the screenshot below
locate "Server name" item and name of the Azure Server follows right after it ("ic0425.database.windows.net" for our example)

Finally, run Intelligent Converters product to convert data from/to Microsoft SQL server. On "Connect to MS SQL server" page you need to select "SQL Server authentication" option, enter the name of Azure SQL Server, username and password (as specified during registration of Azure SQL service on windowsazure.com website) into the appropriate fields.