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.
Hi,
Your tips helped me to proceed a few steps on the Mirror database - Configure mirroring screen.
I set the system assigned managed identity on the sql server (so not a user assigned managed identity, please update the instructions) and that got me to the next step.
Then I received a message that the SQL database tier needs to be at least 100DTU. I changed that too.
Now I get this message: "PowerBI user with prefix itsmart not found."
(itsmart is our company name). I really do not know where this message comes from. What do I have to do?
Many thanks.
I have followed these instructions and now at the same point you are waltheed. I get "PowerBI user with prefix ssaservice not found." [ssaservice] is the name of our server in Azure. I'm not sure what to do either. 😞
