Thursday , October 28 2021

How To Connect Azure Database From SQL Management Studio and from Azure Portal

We will learn how to connect azure database from sql management studio and from azure portal in this article.

  1. How to connect to azure sql database from azure portal
  2. How to connect azure database from sql management studio

How To Connect to Azure SQL Database from Azure Portal

Step1:

Select Query Editor(preview) from the dmcdbpshell window.

Step2:

Sign in at the Query Editor screen.

Step3:

In the Query Editor screen, type the following query.

Let’s create a new orders table

Let’s populate the orders table with sample data.

Step4:

Click Run to execute the query.

Step5:

After the query runs, you will see the following output.

How To Connect to Azure SQL Database from SQL Server Management Studio

We will be connecting and querying an Azure SQL Database from SQL Server Management Studio.

  1. Open SQL Server Management Studio, select “Database Engine” if the Server Type is not selected on the “Connect to Server” screen.
  2. You can see the Server Name information in the Azure portal in Azure SQL Database in the owerview window.
  3. Select SQL Server Authentication as Authentication Type
  4. Enter your login information for Azure SQL Server and press Connect.

If you get an error stating that your client’s IP address does not have access to the server, you need to add the IP Address of the system you want to connect to in Azure SQL Server Firewall. I will explain this step in detail later. If you do not see a screen asking you to enter your IP address, the IP address of the system you want to connect to has been added to Azure SQL Server Firewall.

If your operation is successful, you will be connected to Azure SQL Server as follows. If you do not see the following screen even though you are connected, press F8 and the Object Explorer screen will appear.

 

About Çağlar Özenç

Leave a Reply

Your email address will not be published. Required fields are marked *