Share via

Linked Service (SQL SERVER) Test connection failed

Ehab Mansour 1 Reputation point
Oct 3, 2022, 11:18 AM

Connection Failed
Error Code : 22300

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '==', Database: '==', User: '=='. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified), SqlErrorNumber=-1,Class=20,State=0,
Activity ID: ==.

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

1 answer

Sort by: Most helpful
  1. Nandan Hegde 34,171 Reputation points MVP
    Oct 3, 2022, 2:13 PM

    Hey,
    In linked service you are leveraging Auto IR rather than your self IR :
    247026-image.png

    please switch to self ir and test it out


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.