Hello! I have a SQL database and server set up on the Azure portal, and I'm trying to connect it to Azure Data Studio 2. I want to connect the two by way of a private endpoint so that I have maximum security. The problem is, I can only really get that connection to work through the public connections by using a firewall: I haven't had much success connecting privately otherwise. I tried to set up a VM and private endpoint, but Studio isn't connecting to the VM and the endpoint isn't showing up. I'm afraid I don't fully understand what I'm doing.
If somebody could give me a step-by-step process on how to connect Azure Data Studio 2 to my SQL database through the private endpoint, that would be greatly appreciated.
Thank you!