topic Re: Fabric SQL database is stopped working while calling from WebApi in SQL database

Fabric SQL database is stopped working while calling from WebApi

saimanjiri — Tue, 08 Jul 2025 19:23:44 GMT

Hello,

We are calling Fabric SQL db from webapi through Managed Identity. It was working till yesterday without issue, suddenly started throwing below error from yesterday afternoon. We havent made any changes, what could be the reason? Please assist

Re: Fabric SQL database is stopped working while calling from WebApi

saimanjiri — Tue, 08 Jul 2025 19:26:57 GMT

Hello,

Re: Fabric SQL database is stopped working while calling from WebApi

v-sgandrathi — Wed, 09 Jul 2025 09:21:45 GMT

Hi saimanjiri,

Thank you for reaching out.
The error indicates that the managed identity your Web API uses may no longer have the necessary permissions to access the Fabric SQL database. This can happen due to expired tokens, permission changes, or updates in Azure AD or resource settings, even if you didn't make any changes.

Please check if the managed identity still exists as a database user by running: SELECT * FROM sys.database_principals WHERE name = '<YourManagedIdentityName>'. If it's missing, recreate it with: CREATE USER [<ManagedIdentityName>] FROM EXTERNAL PROVIDER; and assign roles like db_datareader and db_datawriter. Also, make sure your Web API is still set to use Managed Identity in the connection string. If the problem continues, please provide the identity name and error timestamp for further investigation.

Thank you and continue using Microsoft Fabric Community Forum.

Re: Fabric SQL database is stopped working while calling from WebApi

v-sgandrathi — Sun, 13 Jul 2025 16:08:16 GMT

Hi saimanjiri,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

Thank you.

Re: Fabric SQL database is stopped working while calling from WebApi

v-sgandrathi — Thu, 17 Jul 2025 04:38:11 GMT

Hi saimanjiri,

Just checking in -- have you had a chance to review and try the provided solution? Kindly share the status whenever you get a chance.

Looking forward to your response.

Re: Fabric SQL database is stopped working while calling from WebApi

v-sgandrathi — Sun, 20 Jul 2025 09:52:35 GMT

Hi saimanjiri,

.Just a quick check-in! Has your issue been resolved with the information we shared? We’d be delighted to help further if needed.

Thank you.

Re: Fabric SQL database is stopped working while calling from WebApi

saimanjiri — Mon, 28 Jul 2025 16:05:10 GMT

Issue has been resolved after changing the sensitivity label from confidential to General

Re: Fabric SQL database is stopped working while calling from WebApi

v-chmoha — Mon, 28 Jul 2025 23:28:00 GMT

saimanjiri We had similar issue now and is there any reason we need to change sensitivity? IN our case we cannot change to General (even though it worked) due to securoty reasons