Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Mirroring in Fabric - Managed Identity error

Hi everyone! I'm trying to mirror a newly set up Azure SQL Database with sample data. SAMI is activated and I have set up "Login and mapped database user" and a "contained database user". The fire...
data warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    After multiple attempts and adding a security group as an admin in the Azure portal with my credentials, it finally worked. I'm not sure if this was the key to solving the problem or just a coincidence, but as they say, 'if it works, don't touch it'.

    In retrospect, since many potential users of Fabric are former Power BI developers, the manual and documentation could benefit from more details, particularly around the use of the Azure Portal.

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi Anonymous 

 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

I tried to repro the scenario and got the same error. 

Enabling system-assigned managed identity successfully resolved the encountered error.

The error message you encountered when configuring mirroring suggests that a managed identity for your SQL Server needs to be set up and turned on. Managed identities are crucial for secure, seamless authentication between Azure services.

Could you please recheck once the the System Assigned Managed Identity (SAMI) of your Azure SQL Server?

For more details please refer : Enable System Assigned Managed Identity (SAMI) of your Azure SQL logical server

                                               : Managed identities in Microsoft Entra for Azure SQL.

 

If the issue still persists, please do let u know. Glad to help.

 

I hope this information helps.

 

Thank you.