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(99.2, 22%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
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.
Hi @Vijaykumar Dinni,
Thank you for your kindly feedback! Glad to hear the issue is resolved!
It seems that Erland indicates the direction.
I will convert Erland's comment into an answer. Could you please accept the answer to help others who see the thread in seek of help?
Your action would be helpful to other users who encounter the same issue and read this thread.
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
![](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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
@Vijaykumar Dinni Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
@Vijaykumar Dinni Just checking in to see if the below answer helped. 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.
Hi @Vijaykumar Dinni ,
I hope the answers below is helpful. If you find any of them useful, please remember to mark them as the accepted answer. If you need any additional information, please feel free to let us know.
Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for your understanding! :)
Best regards,
Lucy Chen
Have you checked the SQL Server error log for messages that coincide with the login failures?
Can you connect with SSMS?
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.
Great to hear that you were able to solve the issue!
Vijaykumar Dinni Glad to know your issue has been resolved. 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.
Hi @Vijaykumar Dinni ,
May I humbly suggest that choose an answer you are satisfied and 'Accept it.'
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Best regards,
Lucy Chen
Hi @Vijaykumar Dinni,
Thank you for reaching out and welcome to Microsoft Q&A.
Here are a few things you can check:
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
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.