Database Mirroring for a data source (SQL Server) over an On-premises Data Gateway

[waltheed]

In this link
https://www.microsoft.com/en-us/microsoft-fabric/blog/2025/03/31/fabcon-2025-fueling-tomorrows-ai-wi...

It is said that:
"Database Mirroring has been enhanced with key new enterprise capabilities, including a new source (Azure Database for PostgreSQL flexible server) and support for connecting to data sources over the On-premises and Virtual Network Data Gateways."

So my question is: how do I set up Database Mirroring for a data source (SQL Server) over an On-premises Data Gateway?

I cannot find this option in the New Item dialog in the Fabric workspace.
If I try "mirrored Azure SQL Database", I can fill in everything, it recognizes an on prem data gateway, but connecting fails with the error: "We were unable to connect to the data source using an encrypted connection. To use an unencrypted connection, uncheck "Use encrypted connection" and try again.". I unchecked this, but I get the same error.

Does anyone know how to do this?

[v-prasare]

Hi @waltheed,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[waltheed]

Hi @v-prasare, @andrewsommer ,

I managed to install a ssl certificate, and with other tools I am able to set up an encrypted connection. So that seems solved. Now I run into the next error message.
I get this error when trying to connect from the Fabric Mirroring dialog to the on prem sql server:

The database cannot be mirrored to Fabric due to below error: This connection is not of type Azure SQL Database. Unable to retrieve SQL Server managed identities. A database operation failed with the following error: 'Invalid object name 'sys.dm_server_managed_identities'.' Invalid object name 'sys.dm_server_managed_identities'., SqlErrorNumber=208,Class=16,State=1,

I do see a list of tables, I do see a data preview, but I cannot find a way to bypass this and get to the next step. 

Any ideas? 

[v-prasare · Accepted solution]

Hi,

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare]

Hi @waltheed,

Could you please confirm if you have already raised a support ticket for this issue? If not, I recommend creating one so the support team can assist you further.

Thanks,

Prashanth Are

MS Fabric community support

[waltheed]

Not yet, I will do that

[andrewsommer]

For now you still have to select Azure SQL Database; they haven’t yet exposed a separate UI for on-prem SQL Server

You are running into a known behavior in fabric mirroring. 

Fixes/Workarounds:

1. Ensure SQL Server supports encryption:
• Run: SELECT encrypt_option FROM sys.dm_exec_connections WHERE session_id = @@SPID;
• If it returns FALSE, then the server is not using encrypted connections by default.
2. Force encryption on the SQL Server (preferred):
• Enable TLS via server configuration or use a valid SSL certificate.
• In SQL Server Configuration Manager > SQL Native Client > Client Protocols, enable Force Encryption.
3. If not possible, use VNet Data Gateway instead:
• If you're in Azure and using a hybrid setup, VNet gateways may handle encryption negotiation more flexibly.

Please mark this post as solution if it helps you. Appreciate Kudos.

[waltheed]

I managed to install a ssl certificate, and with other tools I am able to set up an encrypted connection. So that seems solved. Now I run into the next error message.
I get this error when trying to connect from the Fabric Mirroring dialog to the on prem sql server:

The database cannot be mirrored to Fabric due to below error: This connection is not of type Azure SQL Database. Unable to retrieve SQL Server managed identities. A database operation failed with the following error: 'Invalid object name 'sys.dm_server_managed_identities'.' Invalid object name 'sys.dm_server_managed_identities'., SqlErrorNumber=208,Class=16,State=1,

I do see a list of tables, I do see a data preview, but I cannot find a way to bypass this and get to the next step. 

Any ideas?