Connection between on-premises SQL server with Azure data factory

Question

Connection between on-premises SQL server with Azure data factory

Robin Kashyap 0

I tried to connect my local SQL server to Azure data factory but getting this error. Credentials are ok I double checked it

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'localhost', Database: 'XXXXXXXXXX', User: 'XXXXXX'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

No process is on the other end of the pipe

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-07-14T10:00:32.3366667+00:00

What does the connection string look like?

Have you checked the SQL Server errorlog for error message that coincides with the connection failure?
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2024-07-15T04:39:24.8133333+00:00

Can you confirm below thing :

As you are trying to connect to on prem SQL server, you might be using SHIR.

Login to the server hosting the SHIR and try accessing the SQL server from that machine and confirm to us whether you are able to do it or not
Chandra Boorla 14,585 Reputation points Microsoft External Staff Moderator

2024-07-15T08:23:23.1066667+00:00

Hi @Robin Kashyap

Thanks for the question and using MS Q&A platform.

Could you please share some additional information on the error message that you are facing here? Appreciate if you could share some screenshot of the error message?

Meanwhile please refer to the below mentioned document which might help you.

Link: https://sqlserver-dba.co.uk/sql-server-errors/fix-sql-server-error-233-no-process-is-on-the-other-end-of-the-pipe.html

Hope this helps. Do let us know if you any further queries.
Chandra Boorla 14,585 Reputation points Microsoft External Staff Moderator

2024-07-17T06:32:55.4866667+00:00

Hi @Robin Kashyap

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.
Chandra Boorla 14,585 Reputation points Microsoft External Staff Moderator

2024-07-18T11:19:11.3766667+00:00

Hi @Robin Kashyap

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.

1 answer

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-07-14T10:00:32.3366667+00:00

What does the connection string look like?

Have you checked the SQL Server errorlog for error message that coincides with the connection failure?
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2024-07-15T04:39:24.8133333+00:00

Can you confirm below thing :

As you are trying to connect to on prem SQL server, you might be using SHIR.

Login to the server hosting the SHIR and try accessing the SQL server from that machine and confirm to us whether you are able to do it or not
Chandra Boorla 14,585 Reputation points Microsoft External Staff Moderator

2024-07-15T08:23:23.1066667+00:00

Hi @Robin Kashyap

Thanks for the question and using MS Q&A platform.

Could you please share some additional information on the error message that you are facing here? Appreciate if you could share some screenshot of the error message?

Meanwhile please refer to the below mentioned document which might help you.

Link: https://sqlserver-dba.co.uk/sql-server-errors/fix-sql-server-error-233-no-process-is-on-the-other-end-of-the-pipe.html

Hope this helps. Do let us know if you any further queries.
Chandra Boorla 14,585 Reputation points Microsoft External Staff Moderator

2024-07-17T06:32:55.4866667+00:00

Hi @Robin Kashyap

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.
Chandra Boorla 14,585 Reputation points Microsoft External Staff Moderator

2024-07-18T11:19:11.3766667+00:00

Hi @Robin Kashyap

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.

Answer 1

Hi @Robin Kashyap

Some workarounds:

Please check SQL Server Configuration Manager and ensure that TCP/IP protocol is enabled for your SQL Server instance.

Ensure the firewall on your local machine or network is not blocking the connection to SQL Server.

In SSMS, enable SQL Server and Windows Authentication in service instance property table.

If still not work, please check SQL Server error logs for any additional error messages that might provide more details about the issue.

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

Connection between on-premises SQL server with Azure data factory

1 answer

Your answer