Cannot connect IR to SQL Server on-prem

Xee 0 Reputation points
2023-07-31T06:52:19.0566667+00:00

Hi all,

I'm struggling to connect my IR to SQL Server 2019 on-prem.

I've allowed the ports 1433, 433 1434 through firewall.

Attached is the error and the IR details to connect to SQL Server.

Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,040 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Xee 0 Reputation points
    2023-08-09T10:29:25.1566667+00:00

    I can however successfully connect my Self Hosted IR to Postgresql database: User's image

    0 comments No comments