How To Query Azure SQL Database From Microsoft SQL Server Management Studio

Introduction

In my previous article, you saw how to create an Azure SQL database and to query the Database in the Azure portal. Azure SQL Database is a relational Database-as-a-Service which provides high performance, reliable, and secure databases used to build data-driven applications and websites. In this blog, you will see how to query Azure SQL database from Microsoft SQL Server Management Studio. As a prerequisite, make sure you have installed the latest Microsoft SQL Server Management Studio and also you have created the server-level firewall rule to access the database from your machine.

Query SQL Database

Log in to the Azure Portal.

Click SQL Databases -> vijaiDB (which I have created in my previous article). Click Overview and you could see the server name and make sure you remember the username and password which is used when you create a SQL database.

 

Open Microsoft SQL Server Management Studio. Enter all the necessary details and connect to SQL database.

 

You will be successfully connected to the database, as shown below.

 

Result

Thus, in this blog, you saw how to query Azure SQL database from Microsoft SQL Server Management Studio.