The error “A transport-level error has occurred when sending the request to the server” ย can occur when the SQL Server client cannot connect to the server. The reason for the lack of connection can become a wrong-configured remote connection. In this case, SQL Server will send the following message:
Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
To solve this problem, try to allow SQL Server to accept remote connections or check your firewall settings. It is possible to enable remote connections with the help of the SQL Server Configuration Manager tool.
