Shared Memory Provider: No process is on the other end of the pipe. Communication link failure

Have you encountered the error Shared Memory Provider: No process is on the other end of the pipe. Communication link failure?

I was doing a sqlcmd from the command line to import large .sql file as it is hanging or it can’t execute from the SQL Management Studio.

If you did, this is how I resolved this issue

sqlcmd -S MyServerName -U sa -P myPassword -d myDatabaseName-i ScriptToExecute.sql -a 32767

Add the parameter -a 32767

Then it all works!