MicrosoftThank you luisaranda for the detailed article and it saved lot of time.
However, I am running into an issue. I am using Excel to connect to the Managed Instance with a CNAME. I looked at options to set excel to trust server cert and came out empty. I started looking to the OLEDB drivers, noticed that OLEDB 19 for SQL serve supports it however, when I try it does not work. Where as ODBC 18 is working fine. I get an authentication error. Can you provide a sample connection string that worked for you with Encryption on and Trust server cert to true.
It works fine from SSMS as well.
