linked services using integration runtime

Question

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

Answer

Hi Thierry Joel Meli Tchinda •,

Please check below and share information from your end to understand the issue better:

1). If issue is due to Server Configuration, please make sure in your Linked Service, Server Name is correctly given like shown below:

User's image

Same as shown in SSMS for your on premise server:

User's image

2). Secondly, if issue is related to User, check the User through which you are connecting is Active and has required settings enabled to login in ADF:

User's image

Go to Security Folder at Server level then Open Properties.

Go to Server Roles and check "sysadmin" as that might help.

Also, got to "Status" section and make sure SQL Server auth is enabled.

3). This could also be a cause that your SQL Service needs a Restart.

Please make sure your on-premise SQL Server Services is at Running in SQL Server Configuration Manager and Network Configuration for your Database has Protocols Enabled:

User's image

Try restart of the Services: User's image

Let us know if above helped or you have some information to share so that we can further troubleshoot.

Thanks

Share via

linked services using integration runtime

1 answer

Your answer