Forum Discussion
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:
- The SQL Server login exists and has the correct permissions.
- The password entered is correct. Double-check for any typos or case sensitivity issues.
- 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.
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.
I share issue as people below after your post. I can connect to database and see the data in preview so this is not a 'connection with the database issue'. This is the last step when I go from Preview to final Mirror Database. It is saying "PowerBI user with prefix [the start of the server address] not found"