SQL: No process is on the other end of the pipe

Symptom

You want to connect to the SQL database but ended with below error,

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)

SQL - No process is on the other end of the pipe

Solution

• Ensure both SQL Server and SQL Server Agent are running. You can determine from the Windows services or SQL Server Configuration Manager.

• Ensure the TCP/IP protocol is enable. You can enable the protocol via SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER.

• Switch the authentication, try to login with Windows Authentication / SQL Server Authentication. Use sa username and password if you have the access.

• Refer to MSSQL: Cannot open user default database. Login failed.