I got this error message when I login to SQL Server 2012 with sql authentication. However, I was able to login with Windows authentication.
Error Message
Cannot connect to <Server Name>.
——————————
ADDITIONAL INFORMATION:
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)
——————————
No process is on the other end of the pipe
——————————
Solution
Enable Sql Authentication and then restart SQL Server Service.