Before connecting SQL Server to Chartio, log in to your Windows Azure account, select SQL Databases from the navigation, then select the name of the database you would like to connect to.
Make note of the server name and port number at the bottom of the page. This is the information you will use in the Host and Port fields when creating a connection to Chartio. Select the Dashboard link at the top of the page.
Scroll down and select the link to Manage allowed IP addresses in the bottom right-hand corner of the screen.
Add a new rule using the following IP address:
Rule Name: Chartio
Start IP Address: 22.214.171.124
End IP Address: 126.96.36.199
Click the Save button at the bottom of the page.
Once you have collected your information from your Windows Azure management console and added access to Chartio’s external IPs, you can follow the instructions to connect SQL Server to Chartio.