I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server.
I am looking to move this server to an Azure Managed Instance and I want to point the DNS CNAME at this server (the MI is in a VNet that is connected to our internal network)
In my testing if I create a new DNS CNAME at the Manage Instance Host ServerName.dnsPrefix.database.windows.net it works from SSMS but not from any of our apps. I think it’s some sort of reverse lookup issue. If I point the App directly at the MI host (ServerName.dnsPrefix.database.windows.net) it works fine.
Is it not possible to point a on Prem DNS CNAME at an Azure MI?
