Connect a SQL Server databased hosted on Azure

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