Deleting Azure SQL Database VNETs

This is quite a new feature (currently in preview) but an important one where we now have the ability to  isolate connectivity to a database to only a given subnet or set of subnets within your VNET. This is not a theory based blog post but a practical one, setting them up is easy but deleting them via the portal is a totally different experience.

This is what my VNETs look like, this is found within the Firewall / Virtual Networks server level setting.

vnets

If you decide that you need to delete the rule you would naturally click the 3-dotted button (on the right) and hit delete, well you would think that! I get a generic error. After a conversation with Azure Support the only way I could delete this was via Azure Cloud Shell.

The error: ErrorMessage: The subscription ‘00000000-0000-0000-0000-000000000000’ could not be found.

Here is how you do it. Click that >_ Button.

cli

If you have not used this before you will get a message around the requirement of storage.

storageNeed

You will need to create a storage area for the files to be held. Once done we are ready to remove VNETs.

cloudshell

Run the below to confirm that you are in the correct subscription. This is very handy when / if you have multiple subscriptions.

az account show

azurecloud

Change subscription if needed, below I am switching to PlayArea.

az account set -s PlayArea

Then the DELETE VNET command.

az sql server vnet-rule delete -n VNET_Production -g AK_Test -s sql-01

Check the VNET section and they will be removed – Its obviously broken functionality via the Portal.

NoVNETs

Hopefully you find this post useful.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s