Error while testing endpoint connection

Vandy — Wed, 29 Mar 2023 11:54:43 GMT

Hi team,

I am facing the below error while testing an endpoint connection while replicating tables from source(Microsoft SQL Server) to target(Oracle).

It would be great if your team could help me overcome the error.

Thanks & Regards,

Vandy

Re: Error while testing endpoint connection

john_wang — Wed, 29 Mar 2023 12:04:03 GMT

Hello @Vandy ,

Thanks for reaching out.

This is a common error in SQL Server client/server connectivity, many varied factors may lead to the same error, eg the firewall setting in SQL Server Server, or incorrect information provided in Replicate Endpoint, etc. we found a few helpful links, please have a try:

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

https://stackoverflow.com/questions/9945409/how-do-i-fix-the-error-named-pipes-provider-error-40-could-not-open-a-connec

If the problem persists, you may try to create an ODBC DSN and use the DSN to troubleshoot the connectivity issue, it's a bit easier than do that in Replicate.

Good Luck,

John.

topic Error while testing endpoint connection in Qlik Replicate

Error while testing endpoint connection

Re: Error while testing endpoint connection