Share via

Azure Data Factory Linked Service to On-Premises SQL Server with named instance

Nestor 46 Reputation points
2020-07-23T15:14:12.393+00:00

Hello,

I'm trying to connect from Azure Data Factory to an on-premises SQL Server using the SQL Server linked service (e.g. servername\instance1). I already have an integration runtime installed, configured, and working (tested with other servers).

Should I put the named instance in the servername field when configuring the linked service? From looking at the JSON, it seems my assumption is correct, but I cannot make this work; the connection cannot be established.

Am I missing something?

13410-new.jpg

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,778 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,427 Reputation points Microsoft Employee
    2020-07-28T21:26:19.87+00:00

    Hi @Nestor-4651,

    Are you still experiencing the issue? If so could you please share the complete error message as requested by Vaibhav?

    Usually the Server Name field in linked service settings will be <servername>\<instance name if using named instance>

    If you still encounter the issue please do share the error message for further assistance.

    Thank you
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.