Post reply

Semaphore timeout period has expired

  • January 7, 2016 at 9:26 am

    #150424

    Hi all

    I've recently started receiving this error when running a query against a server.

    The full error message is:-

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

    If I try to rerun the query it reconnects without an issue and tries again. The timeout happens after around 6 minutes.

    I've just tried a different query on the same server and it gave me the above error message instantly but now appears to be running OK.

    I'm using a Windows 7 laptop with SSMS 2012 and running the query against a SQL2005 server.

    It's only started recently and I haven;'t a clue where to start.

    I've googled the issue but nothing that I can do locally seems to be an option.

    Is there anything anyone can suggest that I can look into?

    Thanks in advance.

  • January 7, 2016 at 9:43 am

    #1850246

    You might have some problems with your network making you lose connectivity with the server or someone (or something) is killing your connection.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • January 8, 2016 at 2:00 am

    #1850418

    Thanks Luis

    Are there any steps I can take to try and find out the cause?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply