A transport-level error has occurred when receiving results from the server

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.