Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Allow Managed identity for Azure Fabric SQL Storage

Hi, I am trying to use the SQL Database storage on Azure Fabric, it is working however now I want to use it from my Azure Function App. However, I keep getting this error. 

{
"message": " SQL query failed: Login failed for user '<token-identified principal>'.Reason: Authentication was successful, but the database was not found or you have insufficient permissions to connect to it."
}


This is a permission issue because when I test it locally using az login, it works.

How can I fix this?

Status: New