Forum Discussion
Mirrored Sql Server Database Failed: Internal system error occurred.
When I try use the fabric mirroring to copy data from a on-premises sql server database, I followed the tutorial to create an on-premises data gateway and enable the cdc of database, and make sure the connection is ok. But it turns out the error below, I couldn't find any details from that page or monitor (cause there was no mirror activity in the monitor), also the troubleshoot from Microsoft Fabric documents didn't help.
Hello XavierYan
On-premises SQL Server is unsupported for direct Fabric mirroring
The native feature only works with:
• Azure SQL Database
• Azure SQL Managed InstanceNot sure which tutorial you are following
please accept the answer if this is helpful
Hi XavierYan ,
Thanks for reaching out to the Microsoft fabric community forum.
As nilendraFabric mentioned on premises sql server is not supported yet and if you do want to ingest your data into Fabric, as a workaround you may use traditional methods of ingesting data into fabric Like Data pipelines. Create a data pipeline within Microsoft Fabric to extract data from your on-premises SQL Server. Use the copy activity to transfer data into Fabric, employing incremental load patterns as needed.If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards
7 Replies
This is in fact now supported, as referenced here: Microsoft Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn
Adding this comment because Copilot is using this article to tell us that SQL Server on prem mirrors are not supported.
Hi XavierYan ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Thanks and regardsHello team, now the Mirrored Sql is online on Fabric, but I'm having this same issue.
Hi XavierYan,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi XavierYan ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi XavierYan ,
Thanks for reaching out to the Microsoft fabric community forum.
As nilendraFabric mentioned on premises sql server is not supported yet and if you do want to ingest your data into Fabric, as a workaround you may use traditional methods of ingesting data into fabric Like Data pipelines. Create a data pipeline within Microsoft Fabric to extract data from your on-premises SQL Server. Use the copy activity to transfer data into Fabric, employing incremental load patterns as needed.If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and RegardsHello XavierYan
On-premises SQL Server is unsupported for direct Fabric mirroring
The native feature only works with:
• Azure SQL Database
• Azure SQL Managed InstanceNot sure which tutorial you are following
please accept the answer if this is helpful
