Thursday , September 29 2022

Connecting And Querying SQL Database From Azure Portal

We will learn how to Connecting And Querying SQL Database From Azure Portal.

1. Select Query Editor(preview) from the Dmcdbpshell window.

2. We log in from the Query Editor screen.

3. On the Query Editor screen, we write the following query.

— let’s create a new orders table

— Let’s populate the orders table with Example datasets.

4. Press Run to run the query.

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

Connecting and Querying SQL Database from SQL Server Management Studio

We will connect and query an Azure SQL Database from SQL Server Management Studio.

1. We open SQL Server Management Studio, if the Server Type section is not selected on the “Connect to Server” screen, we select it as “Database Engine”.

2. You can see the Server Name information in the Azure portal in Azure SQL Database in the owerview window.

3. We choose SQL Server Authentication as the Authentication Type

4. Enter your login information for Azure SQL Server and press Connect.

If you receive an error stating that your client does not have access to the server with your IP address, you need to add the IP Address of the system you want to connect to Azure SQL Server Firewall in order to connect to Azure SQL Server.

I will explain this step in detail later. If you do not see a screen asking you to enter the IP address, the IP address of the system you want to connect to has been added to the -Azure SQL Server Firewall – Firewall.

5. 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, if you press F8, the Object Explorer screen will appear.

About Çağlar Özenç

Leave a Reply

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