High severitydata source
Power BI Refresh Error:
SqlFailedToConnect
What does this error mean?
ADF or Fabric could not connect to SQL Server or Synapse. The server is unreachable from the integration runtime — check firewall rules and DNS.
Common causes
- 1The SQL server name or endpoint URL in the linked service is incorrect
- 2Firewall rules on the SQL server or Azure SQL/Synapse do not allow the integration runtime's IP
- 3The SQL Server is not accessible from the self-hosted integration runtime network
- 4The SQL Server is offline, restarting, or under maintenance
- 5For Azure SQL/Synapse: the 'Allow Azure services' firewall rule is disabled and the IR IP is not listed
How to fix it
- 1Verify the server name in the linked service — for Azure SQL: <server>.database.windows.net
- 2Add the integration runtime's public IP to the SQL Server firewall under Networking → Firewall rules
- 3For Azure SQL/Synapse: enable 'Allow Azure services and resources to access this server' if using Azure IR
- 4Test TCP connectivity from the self-hosted IR machine: Test-NetConnection <server> -Port 1433
- 5Check SQL Server is running and accepting connections via SSMS from the IR machine
- 6For private endpoints: verify the private DNS zone resolves the server name to the private IP