A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)SOLUTION
Change connection type to TCP/IP - and ensure that you use the SQL Server Configuration Manager to enable that protocol on the server.