Forum Discussion

waltheed's avatar
waltheed
Impactful Individual
1 year ago
Solved

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

In this link https://www.microsoft.com/en-us/microsoft-fabric/blog/2025/03/31/fabcon-2025-fueling-tomorrows-ai-with-new-agentic-capabilities-and-security-innovations-in-fabric/?s=08   It is said t...
workspaces
waltheed's avatar
waltheed
Impactful Individual
1 year ago

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's avatar
    v-prasare
    Community Support
    1 year ago

    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's avatar
      waltheed
      Impactful Individual
      1 year ago

      Not yet, I will do that