Mirrored Azure SQL Database Unable To Mirror Using Service Principal Authentication

[sharp-fabricusr]

I'm getting the following error when using the Service Principal Authentication in fabric mirrored azure sql database- A database operation failed with the following error: 'VIEW SERVER SECURITY STATE permission was denied on object 'server', database 'master'.
The user does not have permission to perform this action.'

Here are the steps I've take so far. Followed instructions here to a T Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsof... 

• In Master db - Created a Microsoft Entra ID authenticated login from an existing account and granted the ServerStateReader rol - CREATE LOGIN [[email protected]] FROM EXTERNAL PROVIDER; ALTER SERVER ROLE [##MS_ServerStateReader##] ADD MEMBER [[email protected]];
• In the actual database - Created a user for this login and granted control - CREATE USER [[email protected]] FOR LOGIN [[email protected]]; GRANT CONTROL TO [[email protected]];
• Confirmed role access to my login in the master db using this query SELECT
  sp.name AS LoginName,
  sp.type_desc AS LoginType,
  sp.create_date,
  sp.modify_date,
  sr.name AS ServerRoleName
  FROM
  sys.server_principals sp
  JOIN
  sys.server_role_members srm ON sp.principal_id = srm.member_principal_id
  JOIN
  sys.server_principals sr ON srm.role_principal_id = sr.principal_id
  WHERE
  sp.name = '';
  
• 
• Strange thing is it lets me preview the data in the dialog for all my objects
• 
•  I've referenced both of these issues which are similar but don't actually solve the issue Fabric: Mirrored database assistance : r/MicrosoftFabric (reddit.com) | Re: Mirrored Azure SQL Database error - Microsoft Fabric Community
• The second issue refers to the tutorial but I feel that I've exhausted the options given here

[Anonymous]

Hi @sharp-fabricusr 

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[Anonymous]

Hi @sharp-fabricusr 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks