Share via

Physical connection is not usable - MS SQL DB 2019

Kennedy Noel 0 Reputation points
2024-03-14T09:12:37.8533333+00:00

On the 21st February 2024,

One of our internal applications had encountered and error like the below.

[ODBC Driver 18 for SQL Server]SMux Provider: Physical connection is not usable [xFFFFFFFF].

With how far we have gone now, we see that this issue is very much to do with a temporary network disruption based on the article from Microsoft, https://learn.microsoft.com/en-us/archive/msdn-technet-forums/95fe26d2-2e6c-4c6b-b02d-10794e92dc7a which the experts claims as a bit outdated.

The entities associated in the infra are,

  1. Azure VMs based on Windows with Windows (Windows Server 2019 Datacenter) where the application is installed and configured
  2. Azure SQL Database
  3. The Application is a Delphi and DOT NET based client served through Citrix

Has anyone encountered this and if yes, I would appreciate suggestions on how to prevent this from happening again.

Azure Virtual Machines
Azure Virtual Machines

An Azure service that is used to provision Windows and Linux virtual machines.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kennedy Noel 0 Reputation points
    2024-03-26T13:02:42.3166667+00:00

    We are making our best efforts to connect with DB experts within our organization to evaluate these options that you have put forth. Allow us to come back to you before you decide to resolve this please.

    Was this answer helpful?

    1 person found this answer helpful.

  2. AI answer

    2024-03-14T09:12:37.86+00:00

    Based on the provided context, the error message "Physical connection is not usable" is a general network error that can occur when connecting to a SQL Server instance. This error can be caused by a variety of issues, including network disruptions, configuration issues, or firewall blocking the connection. To resolve this issue, you can try the following steps:

    1. Check the network connectivity between the client and the SQL Server instance.
    2. Verify that the SQL Server instance is running and configured to allow remote connections.
    3. Check the firewall settings to ensure that the SQL Server port is open.
    4. If the issue persists, try restarting the SQL Server service.

    It is also recommended to review the troubleshooting steps provided in the following Microsoft articles:

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.
  3. Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
    2024-03-19T22:37:30.94+00:00

    Kennedy Noel

    Please do check this doc

    Use smart retry/back-off logic to mitigate the effect of transient failures It will be difficult to pinpoint the exact cause of the issue because users who faced similar issue were able to get it resolved using different route. This error can have multiple causes, so it’s essential to investigate thoroughly. I would suggest checking this https://stackoverflow.com/questions/22714569/cannot-get-rid-of-physical-connection-is-not-usable-exception

    SQLSTATE = 08S02, SMux Provider Physical connection is not usable

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.