No Process Is on the Other End of the Pipe

For me the issue was that the SQL server was in Windows Authentication mode only, even though I set it to mixed during the install.

In the object explorer, right click on the server, properties and then the Security page and set Server authentication to SQL Server and Windows Authentication mode.

FYI, I've just had the same error.

I switched to Windows authentication, disconnected, then tried to login again with SQL authentication. This time I was told my password had expired. I changed the password and it all worked again.

It may help to make sure the database specified in the initial catalog exists.

I tried the troubleshooting steps in both microsoft tech articles, and oddly no luck.

I managed to fix the solution by changing my authentication from SQL Server Auth to Windows Auth. Though I am not sure the technical reason why this works?