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 nameis the name at the top of the page, not including the part in parentheses. - You can find the
hostunder Server name in the Essentials section at the top of the page. - The
portfor SQL Server on Azure is always1433. - Click Properties in the left hand sidebar. You can find the
userunder Server admin login. - The
passwordwas 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
Equalsand enter54.68.61.53as the start and end IP. - Click Save at the bottom of the page. Equals should now be able to connect to your database.
Updated 11 months ago
