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
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
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?
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