Equals

Azure supports both SQL Server and MySQL databases. The instructions here are for SQL Server databases only.

Sign into the Azure dashboard and search for “SQL Servers” in the search box at the top.

Once on the list of SQL Servers (note: you want servers not databases), choose the server you want to connect to from the list.

1. Sign into the Azure dashboard and search for “SQL Servers” in the search box at the top.
2. Once on the list of SQL Servers (note: you want servers not databases), choose the server you want to connect to from the list.
    

Find the server in Azure (instructions above).

Select the database you want to connect to at the bottom of the “Overview” page.

The database name is the name at the top of the page, not including the part in parentheses.

You can find the host under “Server name” in the “Essentials” section at the top of the page.

The port for SQL Server on Azure is always <code>1433</code>.

Click “Properties” in the left hand sidebar. You can find the user under “Server admin login” on this page.

The password was set when you created the database. If you do not know the password, ask the person on your team that created the database.

1. Find the server in Azure (instructions above).
2. Select the database you want to connect to at the bottom of the “Overview” page.
3. The database name is the name at the top of the page, not including the part in parentheses.
4. You can find the host under “Server name” in the “Essentials” section at the top of the page.
5. The port for SQL Server on Azure is always <code>1433</code>.
6. Click “Properties” in the left hand sidebar. You can find the user under “Server admin login” on this page.
7. The password was set when you created the database. If you do not know the password, ask the person on your team that created the database.

Find the server in Azure (instructions above)

Select “Networking” under “Security” in the sidebar.

Ensure “Public network access” is set to “Selected networks”. If you changed this setting you need to save at the bottom of the page before continuing.

Under the “Firewall rules” section click “Add a firewall rule”

Name the rule “Equals” and enter <code>54.68.61.53</code> as the start and end IP.

Click “Save” at the bottom of the page. Equals should now be able to connect to your database.

1. Find the server in Azure (instructions above)
2. Select “Networking” under “Security” in the sidebar.
3. Ensure “Public network access” is set to “Selected networks”. If you changed this setting you need to save at the bottom of the page before continuing.
4. Under the “Firewall rules” section click “Add a firewall rule”
5. Name the rule “Equals” and enter <code>54.68.61.53</code> as the start and end IP.
6. Click “Save” at the bottom of the page. Equals should now be able to connect to your database.

Finding the server in Azure

Finding your connection details

Allowing access from our IP