Access Azure SQL Database using SQL Server Management Studio

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.