Mirrored Sql Server Database Failed: Internal system error occurred.

[XavierYan]

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.

[v-nmadadi-msft]

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

[v-nmadadi-msft]

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.

[v-nmadadi-msft]

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.

[v-nmadadi-msft]

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

[nilendraFabric]

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