I am currently following the steps from this (Integrate Your Microsoft Azure Database with Your Wix Site) step by step guide and it doesn’t actually work as it describes.
In step 12 under “Create an Azure database for mySQL” it states " Under Firewall rules , click Add existing virtual network ", well this is no longer an option, so I am assuming you have to click “Add private endpoint” to connect the subnet from the virtual network you create in the step before creating the SQL server.
The documentation states that in the subnet you create to select " Microsoft.Web/serverFarms from the Delegate subnet to a service dropdown, then click Save "
Well the issue is, when you select this option, you are NO longer able to select that subnet as a virtual network for your SQL server.
Furthermore, I disabled the Microsoft.Web/serverFarms option from the subnet I created and I was able to connect that virtual network to my Azure database for SQL.
So now here is possibly the issue, moving down to the section of creating a webapp, all is fine UNTIL it asks you to connect to your virtual network, when I go to select the same subnet I created it is NOT available, and only the default subnet is available.
I have 250 available IP addresses in the subnet I created, the only thing I could think of why it is NOT available for my webapp is because I do NOT have this option selected on the subnet “Microsoft.Web/serverFarms”, but if I do select it, I can no longer connect it to my Azure database.
What am I supposed to do so both nodes can connect to the same subnet?
Edit: Here is the error message I receive when I try to select the subnet we created as the virtual network for my Azure database
“The selected subnet ‘MySubnet’ has a delegation and cannot be used.”