SQLCMD – Named Pipes Provider: Could not open a connection to SQL Server

There might be occasions when trying to connect to a SQL 2008 R2 Instance with SQLCMD that you might receive the error :- Named Pipes…