A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

Anthony Morriss 0 Reputation points
2023-08-02T09:46:58.2866667+00:00

Hi,

We are using SQL Server for many web application. From 31/07/2023 we are getting many sites throwing timeout or connection errors with database operations. Everything I have read online says this is likely a connection issue. How could we check to confirm such things, or are there other possible causes?

Thanks,

Anthony

SQL Server | Other
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 122.3K Reputation points MVP Volunteer Moderator
    2023-08-02T21:36:37.7+00:00

    Have you checked the SQL Server errorlog for accompanying error messages?

    My prime guess, though, would be that this is a issue in your network.

    0 comments No comments

  2. ZoeHui-MSFT 41,496 Reputation points
    2023-08-03T02:14:55.5266667+00:00

    Hi @Anthony Morriss,

    "The semaphore timeout period has expired" is a Network error.

    There is apparently some sort of network problem between the application and the SQL Server.

    Check your Windows system event log and SQL Server errorlog to narrow down the issue.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  3. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-08-03T13:31:34.0466667+00:00

    Hi @Anthony Morriss

    These kinds of errors are a client-side issue and not a Gateway-side or SQL-side issue. You may need to Check firewall settings.  Most likely you have a firewall allowing TCP connections but preventing data to flow to destination.

    If you are using Firewall, make sure you configure it to allow SQL Server access as explained in below document

    Configure the Windows Firewall to allow SQL Server access - SQL Server | Microsoft Learn

    Thank you!

    0 comments No comments

Your answer

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