How to access Azure SQL for troubleshooting using SQL Server Management Studio?
For the latest information on connecting SSMS to an Azure SQL database, please see Quickstart: Use SSMS to connect to and query Azure SQL Database or Azure SQL Managed Instance.
To access the Database hosted on an Azure SQL Server, the SQL Server Management Studio ( SSMS) tool can be used. Prior to accessing the Database, add the local machine IP to the SQL Azure Firewall:
- Go to SQL Server in Azure > 'Set Server Firewall':
- 'Add Client IP' and save it:
- Next step, go to Azure SQL Server and get the 'Server Name':
- Add it in the SSMS login, along with the Username + Password of the SQL Server:
- A prompt to 'Sign-In' will be shown > use the Azure Credentials, and not the SQL server ones:
Note: When using SSMS to connect to an Azure SQL Database, SQL Profiler cannot be run against the database.