There are several reasons why this may not connect, and you can diagnose the issue from the error message. Generally, ensure the integration runtime (IR) is running, verify network and firewall settings on SQL Server to allow incoming connections from the IR's IP range, and check that the authentication and configuration settings in ADF are correctly specified.
![Azure Data Factory Beginner to Pro Tutorial [Full Course]](http://i.ytimg.com/vi/DLmlFlQGQWo/mqdefault.jpg)
![Bulk Copy from SQL DB to Data Lake Parquet using Azure Data Factory [ADF]](/img/n.gif)
what of a case scenario where integration run time doesn't connect to sql server,what should be done
There are several reasons why this may not connect, and you can diagnose the issue from the error message. Generally, ensure the integration runtime (IR) is running, verify network and firewall settings on SQL Server to allow incoming connections from the IR's IP range, and check that the authentication and configuration settings in ADF are correctly specified.