topic Re: SQL on prem mirroring cryptic error in SQL database

SQL on prem mirroring cryptic error

ptmk25 — Thu, 20 Nov 2025 18:52:28 GMT

when trying to configure mirroring in fabric to an on prem sql db

error:

configuring replication: Axios Error network error

dataflow g2 to the dg + connection works

thanks

Re: SQL on prem mirroring cryptic error

lbendlin — Fri, 21 Nov 2025 00:46:20 GMT

I don't think on-prem SQL mirroring is supported yet.

Re: SQL on prem mirroring cryptic error

Anonymous — Tue, 25 Nov 2025 03:59:24 GMT

Hi ptmk25 ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Inaddition to lbendlin point, the reason you’re encountering the “Axios network error” even though the gateway connection test and Dataflow Gen2 are functioning is that on-prem SQL connections are permitted for data ingestion, but mirroring for on-prem SQL isn’t supported yet.
This means the connection itself works, but the mirroring setup fails because the necessary replication layer for SQL Server on-prem isn’t available.

Until mirroring is supported for SQL Server on-prem, your closest options are:

Dataflow Gen2 (with incremental load), or Pipeline ingestion.

Thank you.

Re: SQL on prem mirroring cryptic error

Anonymous — Mon, 01 Dec 2025 05:32:49 GMT

Hi ptmk25 ,

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.

Thank you.

Re: SQL on prem mirroring cryptic error

Anonymous — Fri, 05 Dec 2025 03:53:20 GMT

Hi ptmk25 ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved? If you still require support, please let us know, we are happy to assist you.

Thank you.

Re: SQL on prem mirroring cryptic error

apturlov — Sat, 06 Dec 2025 02:18:34 GMT

ptmk25 I confirm that mirroring for on-premises SQL server is supported and works in Microsoft Fabric. See more information here Microsoft Fabric Mirrored Databases From SQL Server - Microsoft Fabric

There are few details to check in your situation if the issue you are dealing with is still not resolved.

You have to use an On-Premises Data Gateway, aka OPDG, that you need to deploy traditionally on a physical or virtual Windows machine close to your on-premises SQL server. See more information here What is an on-premises data gateway?
When you create a mirrored database in Fabric for your on-premises SQL server you have to create a connection first. The credentials you'll use for that connection will need to have Admin permission for your SQL server to initially configre mirroring. Once the mirroring starts working the Admin permission can be removed. See more information here Tutorial: Configure Microsoft Fabric Mirroring from SQL Server - Microsoft Fabric
Some steps for mirroring configuration may differ depending on your on-premises SQL Server version. Make sure to choose the correct documentation to verify the prerequisites.

If you find this answer useful or solving your problem please consider giving kudos and/or marking as a solution.