CODEWITHSUNDEEP
pythonsql-servervisual-studio-codeazure-sql-database
nilsinelabore
nilsinelabore

Reputation: 5095

Connecting an Azure SQL Database with Visual Studio Code

I was following this article and had referred to this tutorial and tutorial about firewall on connecting Azure SQL Database with Visual Studio Code but I just couldn't find the relevant options in some steps.

Both this article and this tutorial mentioned "Set server firewall" as shown below: enter image description here But I couldn't find "Set server firewall" in my Azure portal. Here is what I see: enter image description here

and this is what I see in Firewall: enter image description here

And I got stuck while trying to add connection on SQL Tools in Visual Studio Code: enter image description here, which is Step 5 in this tutorial. Has the Azure portal changed or is it that I missed out any steps?

Edit:

I got stuck at Step 6 in this tutorial. Is there an alternative solution?

enter image description here

Upvotes: 0

Views: 2226

Answers (1)

Carl Zhao
Carl Zhao

Reputation: 9511

Thanks to @Preben Huybrechts for the comment.

Yes, as @Preben Huybrechts said, you must first navigate to the SQL Server resource, then select the server, and then you can manage the server firewall in it. Before that, you must first create a SQL Server resource and SQL database.

enter image description here

For how to set up the firewall, you can check this link.

Update 1:

You need to install "SQL Tools" according to step 4 of the document.

enter image description here

Update 2: enter image description here

enter image description here

Upvotes: 1

Related Questions