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

Posted on 2011-10-10
Last Modified: 2012-08-13
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?

Question by:aplusexpert
    1 Comment
    LVL 15

    Accepted Solution

    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).


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now