No process is on the other end of the pipe (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 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:

  • How does SqlConnection manage IsolationLevel?
  • Split the given date into days
  • JTDS driver not working for Sql Server 2008R2 and Denali Native SSPI library not loaded. Check the java.library.path system property
  • Insert a csv file into Azure SQL from an Azure Blob
  • SQL Server: collect values in an aggregation temporarily and re-use in the same query
  • How to write update to add column with value for existing
  • MSSQL error

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

  • get date of all saturdays in a given year - sql server
  • Select rows containing the group-wise maximum of a column
  • SQL - 2 Counts in one query
  • Rendering bytes from sql server to an image control?
  • Create a table with unique values from another table
  • Good books or sites for advanced SQL queries or puzzles?
  • 6 Solutions collect form web for “No process is on the other end of the pipe (SQL Server 2012)”

    To solve this, connect to SQL Management Studio using Windows Authentication – if this didn’t work, you may need to reinstall SQL Server – then right-click on server node Properties->Security and enable SQL Server and Windows Authentication mode. If you’re using ‘sa’ make sure the account is enabled. To do this open ‘sa’ under Logins and view Status.

    enable sa admin

    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 dont alert, even if you create a user with SQL Authentication only.

    So the answer is: Switch from Windows to SQL Authentication

    Please check this also enter image description here Also check in configuration TCP/IP,Names PipeLine and shared memory enabled

    Also forcing the TCP/IP connection (by providing 127.0.0.1 instead of localhost or .) can reveal the real reason for the error. In my case, the database name specified in connection string was incorrect.

    So, here is the checklist:

    • Make sure Named Pipe is enabled in configuration manager (don’t forget to restart the server).
    • Make sure the database you are connecting to exists.
    • Make sure SQL Server Authentication (or Mixed Mode) is enabled.

    Also you can try to go to services and restart your Sql server instanceenter image description here

    I have the same proplem
    “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.)”

    My connection is:

    server=POS06\SQLEXPRESS; AttachDbFilename=C:…\Datas.mdf;Initial Catalog= Datas; User ID= sa; Pwd=12345; Connect Timeout=10;

    But My SQL is POS06\MSQL2014

    Change the connection string to

    server=POS06\MSQL2014 ; AttachDbFilename=C:…\Datas.mdf;Initial Catalog= Datas; User ID= sa; Pwd=12345; Connect Timeout=10;

    it worked.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.