Mirrored Azure SQL DB - 'VIEW SERVER SECURITY STATE permission error

Hello jsarali ,

Thank you for reaching out to Microsoft Fabric Community Forum.

lbendlin Thank you for your quick response.

When configuring Azure SQL Database mirroring to Microsoft Fabric, the following error may occur:

"Unable to retrieve SQL Server managed identities. VIEW SERVER SECURITY STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action."
 

This error is caused by missing server-level permissions. Even if the user has full database-level access, Microsoft Fabric requires visibility into server security metadata to complete the mirroring process.

You can try,

1. Connect to the Azure SQL logical server as a Server Admin or Azure Active Directory Admin.
2. Grant the required permissions to the user or service principal accessing the database from Fabric:

GRANT VIEW SERVER STATE TO [UserOrServicePrincipal];
GRANT VIEW SERVER SECURITY STATE TO [UserOrServicePrincipal];

• These permissions must be granted at the server level, not just at the database level.
• If permission cannot be granted directly, ensure the user is configured as an Azure AD Admin on the SQL Server.
  

Regards,

B Manikanteswara Reddy

This issue got resolved once I could grant the necessary permisions and after increasing the DTUs on the Azure SQL Database.