ERROR:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.)
EXPLANATION:
When you run a query against a remote server from a client, you encounter this error when the connection with the server breaks while the query is running.
For example, you have established a connection to the remote server via the VPN, your internet connection is broken, then you receive this error.
SOLUTION:
Make sure your Internet connection and VPN connection are healthy.
