Similarly, we can connect Azure Data Studio to Azure SQL using the below steps. Check out how to create an Azure SQL database if you have not yet created your Azure SQL database.
- Open Azure Data Studio on your PC.
- Click New dropdown –> Click the New Connection option, or click Create a Connection button.
3. On the Connection window, provide the below details.
- Connection type: Choose the connection type as SQL server.
- Choose the Parameters option.
- Server: Specify the server name of your Azure SQL. You will get the server name by navigating to the Azure SQL database in the Azure Portal. Refer to the below note.
- Authentication type: Choose SQL Login as the authentication type.
- Username and Password: Specify the Username and password you specified during the Azure SQL database creation in the Azure Portal.
- Finally, click on the Connect button.
Note: Navigate to the Azure SQL database in the Azure Portal and click on the Copy to Clipboard button next to the server name to copy the server name.
You might get the error an instance-specific error occurred while establishing a connection to SQL server after clicking the Connect button.
4. Click the Add an Account dropdown and then the Add an Account option.
5. Login with your Azure credentials and click the OK button on the next pop-up.
4. Now, we can connect the Azure Data Studio with Azure SQL DB successfully.
Video Tutorial
You may also like following the articles below
- How to Connect Azure Data Studio to SQL Server (Easy Steps)
- How to connect to Azure SQL Database from Visual Studio Code
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.
