Semaphore Timeout Did What?

Last week I had a blog about getting better error messages out of SQL Agent Jobs.  In that blog I had encountered the following error message:

Error: 2010-06-23 19:00:30.68
Code: 0×00000000
Source: Execute SQL Task
Description: TCP Provider: The semaphore timeout period has expired.
End Error

The downside is that I don’t have a good explanation for why this error occurred.  I talked to those that would investigate it and handed it off. 

The point for today is that after a lot of searching when this error came up, it turns out that there is a Microsoft KB article that is worth taking a look at when you encounter this error:

Advanced network adapter troubleshooting for Windows workstations

If you encounter this error, I wish you luck.  And hopefully you found the link I referenced faster than had I not put this out there.