Hi @saurabh ,
Thank you for the reply. As per the error message, it looks like your managed Identity doesn't have access to the Synapse SQL pool, or the SQL connection string in the Azure function might not be correct.
Can you please validate them both?
On Synapse SQL end:
CREATE USER [<identity-name>] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [<identity-name>];
ALTER ROLE db_datawriter ADD MEMBER [<identity-name>];
GO
On the Azure function end:
The managed identity connection string should be in this format:
Server=demo.database.windows.net; Authentication=Active Directory Managed Identity; Database=testdb
If both are configured correctly and still having issues, If you have a support plan, you may file a support ticket for deeper investigation; if you don't have a support plan, please let me know. I can enable one-time free support for you to work closely on this matter.
I am looking forward to hearing from you.