Connecting to the Fabric SQL Database using the on premise gateway (OPD)

Recently, I worked on a case where user tried to copy the data from the source Azure SQL Database to target Fabric SQL Database through the pipeline using on premise gateway got the following error message.

Error message:

message: Copy failed with error: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxxxxxxxxxxxxxxxxxxx.database.fabric.microsoft.com,1433', Database: 'xxxxxxxxxxxx', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.Connectors.MSSQL,StackTrace=   at Microsoft.DataTransfer.Connectors.MSSQL.Connect.MSSQLConnectionProvider.OpenConnection(RetryPolicy retry)
   at Microsoft.DataTransfer.Connectors.MSSQL.Connect.MSSQLConnection.OpenInternal(RetryPolicy retry)
   at Microsoft.DataTransfer.Runtime.ConnectionContextExtension.ExecuteWithConnectionContext(IConnection connection, Action action, ConnectionContext context, Boolean needDisposeConnection)
   at Microsoft.DataTransfer.Runtime.PipelineItemProfilerTelemetry.PreProcessSink

Also, user tried to connect to the Fabric SQL Database from the On premise Gateway (client machine) using the SSMS got the following error message.

We found that connections from the source machine to the target Fabric SQL Database were denied because they were using port 11058.

Resolution:

When we create a Fabric SQL Database, it will use the "redirect" connection policy by default. This means that the client machine's firewall must allow ports ranging from 11000 to 11999 to ensure a successful connection to the Fabric SQL Database.

Disclaimer: Please be aware that the products and options discussed in this article are subject to change. This article discusses the connectivity issues encountered with the Fabric SQL Database when using the redirect connection policy in March 2025.

References:

What is Fabric SQL Database?

https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql#connection-policy

https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

https://learn.microsoft.com/en-us/fabric/database/sql/feature-comparison-sql-database-fabric

https://learn.microsoft.com/en-us/fabric/database/sql/authentication

https://learn.microsoft.com/en-us/fabric/database/sql/limitations