Forum Discussion

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
2 years ago

Cannot create a mirrored server in Fabric

I'm trying to set up a Mirrored Azure SQL Server and database in my Fabric Workspace. It does not work.  Additionally, every time I try, after putting in the servername and database name, it auto c...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
2 years ago

Anonymous Yes, I went through the Prerequisites (again). Everything is set up per the list, as far as I can tell.

 

One curious note: Every time I walk through the mirroring setup and try a different access method, like a different access method, I get a new Connection:

The above screenshot shows THREE existing connections. But when I go to the gear icon and select "Manage connections and gateways" none of those three show up. I would like to clean up these failed attempts but cannot find them listed anywhere. What is going on with that?

 

Could any of it be due to the fact that I am accessing the tenant via a guest account and B2B? I am a Fabric Administrator and have full control over the Fabric environment, Admin Portal, Azure SQL Server and Database, etc.

  • hackcrr's avatar
    hackcrr
    Icon for Memorable Member rankMemorable Member
    2 years ago

    Hi, ToddChitt 

    If the connection is not visible in Manage Connections and Gateways, try clearing your browser cache and cookies. check for any hidden connections by navigating to Data Settings in the Fabric workspace.
    Guest Accounts and B2B Notes:
    Ensure that your guest account has the necessary permissions to Azure SQL Server and the Fabric workspace. Verify that the guest account is properly configured and granted access.
    Error Handling and Logging:
    When you encounter an error, make a note of the Activity ID and check the logs in the Azure portal for any detailed error messages. Use the Activity ID to raise a support ticket with Microsoft for more specific troubleshooting.

    If you don't see connections to clean them up, try using PowerShell or the Azure CLI to list and remove the connections.

    The following is a sample PowerShell script for a connection in the Power BI workspace:

    # Install the required module if not already installed
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser

# Import the module
Import-Module MicrosoftPowerBIMgmt

# Login to Power BI
Login-PowerBI

# Get a list of connections in the workspace
Get-PowerBIDataSource -WorkspaceId "YOUR_WORKSPACE_ID"

    The following is a sample PowerShell script for deleting connections in a Power BI workspace:

    # Install the required module if not already installed
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser

# Import the module
Import-Module MicrosoftPowerBIMgmt

# Login to Power BI
Login-PowerBI

# Remove a data source
Remove-PowerBIDataSource -Id "CONNECTION_ID" -WorkspaceId "YOUR_WORKSPACE_ID"

     

    Best Regards,

    hackcrr

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.