Semaphore timeout period has expired

• richardmgreen1

  SSChampion

  Points: 10387

  More actions

  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.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  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

• richardmgreen1

  SSChampion

  Points: 10387

  More actions

  January 8, 2016 at 2:00 am

  #1850418

  Thanks Luis

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