Unable to Connect to Azure SQL Database from Fabric Notebook Using Workspace Managed Identity

Hello navakanth_DE,

Workspace Identity authentication from a Fabric Notebook is not currently supported.
I hope that this will soon be the case.

This means that only user authentication is currently possible. So you need to add your user to the Azure SQL Database, then it would work.

The situation is different for a data pipeline in Microsoft Fabric, where it works.

Here is some more documentation on what Workspace Identity can currently be used for.

https://learn.microsoft.com/en-us/fabric/security/workspace-identity-authenticate

Best regards