Login to the Microsoft Azure Portal and navigate to the database you would like to connect
Under "Settings" click on "Connection Strings"
Click "ODBC" to view the connection string details, taking note of the Server URL (e.g. wayscript-test.database.windows.net), Port (e.g. 1433), Database (e.g. wayscript-test), and Uid (e.g. captain)
In the SQL Module Account Selector, click "Add an Account"
Enter the information gathered from the connection string above, including the password for your database user
Click "Submit" to create the new account
In the SQL Azure Portal, navigate to the "Overview" page for your database, then click on "Set server firewall"
2. Add all of the IP Addresses described in the page below to your database firewall settings