TCP Provider: The semaphore timeout period has exp

问题:

In Sql Server2008 R2 and Windows Server 2008R2, when I start Replication I have this error:

TCP Provider: The semaphore timeout period has expired

Please help me to solve it.

回答1:

in order to fix the error:

System.IO.IOException: The semaphore timeout period has expired.

​Solution​

I have done below NIC changes to resolve this error.

1. Open the Network and Sharing Center.
2. Right click on Ethernet Adapter>>Properties
3. Select Client for Microsoft Networks
4. Click on Configure Tab
5. Click on Advanced Tab

6. And then - Disable the below settings

   • IPv4 Checksum offload
   • Large Send Offload V1(Ipv4)
   • Large Send Offload V2(Ipv4)
   • TCP Checksum Offload(IPv4)
   • UDP Checksum Offload(IPv4)

After disabling the above settings; it resolved our Semaphore error.