Forum Discussion
Database Mirroring for a data source (SQL Server) over an On-premises Data Gateway
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
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:
- 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.
- 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.
- 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.
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?