Azure (SQL Server) connection guide

Connect a SQL Server databased hosted on Azure

Ben McRedmond avatar
Written by Ben McRedmond
Updated over a week ago

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

Finding the server in Azure

  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.

Finding your connection details

  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 1433.

  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.

Allowing access from our IP

  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 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.

Did this answer your question?