Press "Enter" to skip to content

Connection Failed: ADF with SSIS Integration Runtime

Andy Leonard diagnoses a problem:

I clicked the “More” link to display details in the blue box

To provision new Integration Runtime, Azure SQL DB server should not have existing SSISDB. If this SSISDB was once associated with an SSIS IR, you can re-associated it with another SSIS IR (for more info see here).

Click through for Andy’s solution to the problem.