No process is on the other end of the pipe SQL Server 2012

Question

I've got this 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)

I know, there are similar questions on this site, and the answer is, to enable TCP/IP and pipes. But I enabled both, and still doesn't work:

I am using Microsoft SQL Server 2012 and the user has full permissions.

Answer 1

By default, the server was configured to only accept Windows Authentication. It's challenging to determine the cause of the mistakes because there is no notification of this. Even if you merely create a user with SQL Authentication, the SQL Management Studio does not alert you.

Solution:

 Switch from Windows to SQL Authentication:

1. Right-click on the server name and select properties;
2. Select the security tab;
3. Enable the SQL Server and Windows Authentication mode;
4. Restart the SQL Server service.

You can now connect with your login/password.