Forum Discussion
SQL on prem mirroring cryptic error
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
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.
5 Replies
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.
I don't think on-prem SQL mirroring is supported yet.
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.
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.
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.
