Cannot connect to SQL Database. No process is on the other end of the pipe

Vijaykumar Dinni 0 Reputation points
2024-06-16T07:17:35.5833333+00:00

I am trying to create a Linked Service on ADF for SHIR (this is up and connected to ADF) and when i fill in all details and click Test Connection. I get this error message:

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'XXX', Database: 'AdventureWorksLT2022', User: 'XXX'. 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

NOTE: The SQL Server instance is running and SHIR is fine.

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

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 106.3K Reputation points
    2024-06-16T09:29:32.9+00:00

    Have you checked the SQL Server error log for messages that coincide with the login failures?

    Can you connect with SSMS?

    1 person found this answer helpful.

  2. LucyChenMSFT-4874 2,985 Reputation points
    2024-06-17T05:44:24.7766667+00:00

    Hi @Vijaykumar Dinni,

    Thank you for reaching out and welcome to Microsoft Q&A.

    Here are a few things you can check:

    1. Your Credential are correct username and password, you can get username by entering in command prompt.
    2. Your SQL database is under firewall rule and allow it to use SHIR.
    3. Could you please try to connect it with SSMS?

    Please feel free to share your issue here if you have any confusions.

    Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

    Best regards,

    Lucy Chen


    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".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    0 comments No comments

  3. Smaran Thoomu 12,610 Reputation points Microsoft Vendor
    2024-06-18T05:42:03.47+00:00

    Hi @Vijaykumar Dinni

    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

    Ask: I am trying to create a Linked Service on ADF for SHIR (this is up and connected to ADF) and when i fill in all details and click Test Connection. I get this error message:

    Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'XXX', Database: 'AdventureWorksLT2022', User: 'XXX'. 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

    NOTE: The SQL Server instance is running and SHIR is fine.

    Solution: Thanks for your input. I see it had logged an error for login attempt in sql server log. I followed the stackoverflow link on fixing "https://stackoverflow.com/questions/8441158/an-attempt-to-login-using-sql-authentication-failed" and with the security changes with enabling mixed mode server authentication, it worked. Thanks.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments