Link to home
Start Free TrialLog in
Avatar of aplusexpert
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
ASKER CERTIFIED SOLUTION
Avatar of gplana
gplana
Flag of Spain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial