topic Re: Mirrored Sql Server Database Failed: Internal system error occurred. in Data Warehouse

Mirrored Sql Server Database Failed: Internal system error occurred.

XavierYan — Wed, 26 Feb 2025 07:03:24 GMT

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.

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

nilendraFabric — Wed, 26 Feb 2025 20:46:31 GMT

Hello XavierYan

On-premises SQL Server is unsupported for direct Fabric mirroring

The native feature only works with:
• Azure SQL Database
• Azure SQL Managed Instance

Not sure which tutorial you are following

please accept the answer if this is helpful

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

Anonymous — Thu, 27 Feb 2025 11:38:10 GMT

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

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

Anonymous — Tue, 04 Mar 2025 05:01:53 GMT

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.

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

Anonymous — Fri, 07 Mar 2025 10:32:17 GMT

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.

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

Anonymous — Mon, 10 Mar 2025 11:25:23 GMT

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 regards

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

lfparaujo — Wed, 21 May 2025 19:56:30 GMT

Hello team, now the Mirrored Sql is online on Fabric, but I'm having this same issue.

Re: Mirrored Sql Server Database Failed: Internal system error occurred.

johnkowalke — Thu, 11 Jun 2026 15:52:27 GMT

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.