Azure
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
- 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.
Finding your connection details
- 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 always1433
. - Click Properties in the left hand sidebar. You can find the
user
under Server admin login. - 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
- 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 enter54.68.61.53
as the start and end IP. - Click Save at the bottom of the page. Equals should now be able to connect to your database.
Updated 8 months ago