This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 67%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Hi Team,
I am trying to create a linked Service in the Azure Data Factory for setting up a connection to SQL Database on - prem server using Windows Authentication in ADF Linked Service to copy data to Cloud and my Test Connection Failed with below Error -
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'servername.database.windows.net', Database: 'xxx', User: 'xxx'. 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)
To add I am able to connect to the same Server and Database using Sql Server Management Studio.
Need help to resolve the issue.
Thanks,
Nalini.
An Azure service for ingesting, preparing, and transforming data at scale.
As this is an on prem database, you would need to use Self hosted IR to access that database via ADF.
The above error is because you are using Azure IR and the On Prem database is hosted within a network
Hi Nandan,
Thanks for the response.
I am able to connect to the SQL Server initially after setting up the SelfHosted Integration Runtime. Now, Again the LinkedService Test connection is failing again with below error & My Service still shows it is running Status under Manage in Datafactory.
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xx\xx', Database: 'xxx', User: 'INTRA\xxx'. 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)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
This typically indicates that the SHIR cannot reach the SQL Server due to network issues, incorrect server name formatting, firewall rules, or authentication failures. Although the SHIR service still appears running in ADF, the underlying connection may have been disrupted
If firewall settings changed after the initial setup, the SHIR machine might be blocked from accessing SQL Server. To fix this, add an inbound rule on SQL Server to allow traffic from the SHIR machine and ensure Windows Defender Firewall permits connections on port 1433.
If all configurations are correct but the issue persists, restart the SHIR service and the SQL Server service to refresh connections
For more information, please refer the below doc
https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql#steps-to-fix-common-connection-issues
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance?view=azuresql
However, if the issue persists or you encounter any roadblocks, I will be happy to provide an alternative solution. Let me know how it goes, and I am happy to assist further.
@Nalini Bhavaraju
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
@Nalini Bhavaraju
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.