Ms Sql Server Management Studio Error while executing a SQL. A transport-level error has occurred when sending the request to the server.

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.)

RootCause:  This error occurs when there is no active connection to the database.  

FIX:  Close the current query window and open a new query window and execute the sql.