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?