DF-MSSQL-InvalidFirewallSetting - TCP/IP The TCP/IP connection to the host has failed.

Question

Hi ,

While connecting to SQL server in pipeline using copy activity, data is fetched and stored in SQL server or blob storage successfully.

But while connecting the same dataset as source in the data flow getting this error -

DF-MSSQL-InvalidFirewallSetting

The TCP/IP connection to the host has failed. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.

Thank you,
Shivani Tyagi

Answer 1

Hi @Shivani Tyagi ,
I hold the view that this is a connection problem, and you can check this official link : https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql , I hope this can be helpful.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 2

Hi @Shivani Tyagi ,

Thank you for posting query in Microsoft Q&A Platform.

To access on premise SQL Server, you need to use Azure Data Factory or Synapse workspace Managed Virtual Network using a private endpoint. Refer to this tutorial for detailed steps.

Please check below link to understand about SQL server connector for mapping data flows.
https://learn.microsoft.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory#mapping-data-flow-properties

Hope this helps. Please let me know if any queries.

---------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification