dns – How to point custom domain name to Azure SQL Managed Instance

I want to point a custom domain name, for example mydatabase.com to my SQL Managed Instance so client applications communicate through that domain instead of the hostname provided by Azure of the shape xyz-abc.1234567.database.windows.net. I first attempted this by adding a CNAME record in my DNS Provider (external to Azure) and while the DNS lookup returns the same IP address for both domains, I can’t connect to the instance (for example from SSMS).
I’ve gone through tons of Azure docs but can’t seem to find the right way to approach this. Would really apprechate the help!