Before discussing the complete steps for this functionality, consider the prerequisites needed here.
- You must have an Azure subscription. You can create your free Azure Account.
- Ensure to install Visual Studio Code.
- You must create an Azure SQL Database.
Assuming you are ready with all these prerequisites. Follow the below steps
- Open Visual Studio Code from your local machine.
- Click on extensions from the left navigation –> search for mssql and click on the search result SQL Server (mssql) –> click on the Install button, as shown in the screenshot below.
3. Now, you can see a SQL Server icon on the left navigation. Click on the SQL server icon –> click on the + Add connection button, as shown in the screenshot below.
4. Enter your Azure SQL server name and then hit the enter key from your keyboard.
5. Enter your Azure SQL database name and press enter. You can also press enter directly without entering the name.
6. Choose the Authentication type based on the option you selected while creating the Azure SQL database. For me, it is SQL Login.
7. Enter the username that you entered during the Azure SQL database creation time.Press enter.
8. Now, enter the password you set during the creation time.Press enter.
9. Select Yes or No if you want to save the password or not based on your requirements. Press enter.
10. Enter a profile name and press enter.
11. You can see I connected to my Azure SQL Database successfully. Check out the screenshot below.
Note: There might be a chance after step 10, you will get the below error.
You can fix this error An instance-specific error occurred while establishing a connection to SQL server quickly and enjoy.
Video Tutorial
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.
