Before starting the actual topic, let’s discuss the prerequisites needed here.
Table of Contents
Prerequisites
Below are the prerequisites needed here.
- You must have an Azure subscription or account. If you don’t have an Azure account, you needn’t worry- you can create a free Azure account now.
- You must download and install Azure Data Studio on your PC.
- Install SQL Server Management Studio’s latest version on your machine.
Assuming you are ready with all the prerequisites needed here, let’s start with the steps needed to connect to the SQL server from Azure Data Studio.
- Launch Azure Data Studio on your PC.
- Click on the New dropdown –> Then click on the New Connection option, or click the Create a Connection button.
3. On the Connection window, provide the below details
- Connection type: Choose the Connection type as Microsoft SQL server.
- Select the Parameters radio button.
- Server: Provide the Server name.
- Authentication type: Choose the authentication type and the other details based on the authentication type.
Finally, click on the Connect button.
Note: To get the server name and authentication details, open the SQL server management studio, and on the Connect to server pop-up, you will get all the details.
Now, you can see that we can connect the Azure Data Studio to the SQL server successfully without any issues.
You may also like following the articles below
- How to connect to Azure sql Database from Azure Data Studio
- Azure SQL Database Vs. SQL Server
- How to backup Azure SQL database
- How To Connect To Azure SQL Database
Wrapping Up
This article discussed how to connect Azure Data Studio to the SQL server and Azure SQL database. Thanks for reading this article. I hope it helps !!!
I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.
