Search code examples
sql-serversql-server-2012

How to fix a "No process is on the other end of the pipe" error in SQL Server 2012

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 enabled TCP/IP and Named Pipes and it still doesn't work:

MSSQL error

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

Solution

  • The server was set to Windows Authentication only by default. There isn't any notification, that the origin of the errors is that, so it's hard to figure it out. The SQL Management studio does not warn you, even if you create a user with SQL Authentication only.

    So the answer is: Switch from Windows to SQL Authentication:

    1. Right click on the server name and select properties;
    2. Select 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.

    Here are the directions by Microsoft: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver15