Mirroring Azure SQL database in Fabric

Hi waltheed ,

The error message "Login failed for fabric_user" typically indicates an issue with the authentication process. Since you're connecting to an Azure SQL Database, ensure that:

1. The SQL Server login exists and has the correct permissions.
2. The password entered is correct. Double-check for any typos or case sensitivity issues.
3. The Azure SQL Database server's firewall settings allow connections from Microsoft Fabric. You might need to add the IP address of the Microsoft Fabric service to the allowed list. More details on configuring firewall rules can be found here.

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.

Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsoft Fabric | Microsoft Learn

Managed identity in Microsoft Entra for Azure SQL - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.