aplusexpert
asked on
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 asp.net 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?
Thanks
I am trying to synchronize the "Destination Database" with the "Source Database" using asp.net 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?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.