SQL Server Mirroring keeps giving error when I want to add more tables

Hi sholy29 

Thank you for the detailed update and the screenshot.

The error message “Test connection failed. The Data Factory runtime is busy now. Please retry the operation later” shows that the issue is now due to a runtime resource contention in Microsoft Fabric’s backend, specifically the Data Factory runtime that manages mirroring and data movement. This usually happens when there are many concurrent operations, like active mirroring or data transformation jobs, which can temporarily use up available resources.

To address this, it’s recommended to wait 15–30 minutes and then try again, as these issues often resolve themselves. Also, try to avoid running overlapping workloads at the same time pause any active pipelines, Dataflows, or Power BI dataset refreshes if possible.

Additionally, If you have access, use a dedicated Fabric capacity workspace, since lower SKUs or trial capacities are more likely to encounter this issue. You might also try using a new browser session or incognito window to prevent session token problems. For authentication, using a linked service with a stored SQL username and password is valid for mirroring, so no changes are needed there.


Thank you for being part of Fabric Community Forum.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.