Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.)
Description: Again this error occurred due to slow network connection or bad network configuration. For example, when we try to connect a SQL Server through application, and the request taking so much for the output. The networking layers will bubble this error to SQL Server which will present to us as provider: TCP Provider, error: 0 – The semaphore timeout period has expired.
Solution: Nothing related to code logic, just check the network connections are working properly or the server is up and running. Contact your Network Administrator.