Connect to Azure SQL via IP -- private endpoint

Question

We have an Azure SQL database with no public access and a private endpoint. In our small data movement network we use azure dns, and thus pick up the IP via the private zone created.

However, we have another subnet which does not use azure DNS, and the owners of this network do not want to add in the dns records for the private endpoint.

I understand that Azure SQL is behind a load balancer, hence it needs to know what actual "server" you are connecting to.

Is there a way (in SSMS or otherwise) to connect via IP but also pass along the "name" it wants to connect to? Kind of like a host header in http?

The only alternative is a hosts file, which really is not a great solution.

Thanks

Answer 1

Hi @Bill Williamson Thank you for posting your question on Microsoft Q&A.

1. create a private link by following the steps in this documentation
2. create a private endpoint by following this doc
3. Here you can go ahead create a private DNS zone for the endpoint or you can only go with Ip and create.

After that open SSMS and give Server Name as IP and in username give adminusername followed by servername with @.
Find the screenshot below.

Also check the Trust server certificate checkbox in connection properties.

Please let me know if the answer helped.
Regards,
Oury