Linked Server Error - Physical connection is not usable, Unable to open a logical session

Hello Experts,

I am trying to synchronize the "Destination Database" with the "Source Database" using application and linked server approach.

Linked server is created at client and connection established successfully, but when I try to synchronize data through the application, it throws exception:

"SMux Provider: Physical connection is not usable [xFFFFFFFF].
OLE DB provider "SQLNCLI10" for linked server <<linked server name>> returned message
"Unable to open a logical session"."

How can I resolve this error?

Who is Participating?
gplanaConnect With a Mentor Commented:
Have you tried to access to linked server from SQL-Query Analyzer ?

Maybe your server is down or maybe there is a network problem (for example a DNS problem which doesn't allow to solve the linked server name).

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.