Anybody try to connect Azure Cognitive search to a Dataverse DB via SQL connection option .. my user is a cloud (onmicrosoft.com) user and I can connect via SSMS using Integrated with universal MFA, but can't seem to connect via Azure Cognitive search. I just get BadRequest: Login failed: Request is not authenticated.
My connection string looks like this:
Server=tcp:orgaXXXXX.crm.dynamics.com,1433;Initial Catalog=orgaXXXXX;Connect Timeout=15;Encrypt=False;Trust Server Certificate=False
I've tried a number of other combinations with no luck.
I am able to connect via SSMS but note my user is a cloud user and authentication type is with universal MFA
I have confirmed the user has all the needed access to query the table in question from SSMS and SSIS.
Thanks.
