I can't find anything online that explains how to resolve this error, does anyone have any idea?
SQL Server database port 1433 is exposed to the Internet. We do not recommend exposing database ports to the Internet and suggest only exposing them to your front-end tier inside your virtual network
I've tried using service tags and Address Space but this just blocks connections. I need to be able to connect to the SQL Virtual Machine through SSMS and also have data factory and an azure sql server instance talk to it, but my only choices are either opening the thing up to all IP addresses (in which case this error is returned), or just limiting it to my own IP address. I can't believe googling this problem gives me NO results but here we are.
I don't even know where to start. Is there anywhere with instructions on how to only expose a port to a virtual network, so I can have it connect to Azure SQL Server and data factory instances?