No Process Is on the Other End of the Pipe

问题:

I receive this error when I try to connect to SQL Server 2005. I have enabled TCP/IP, Named Pipes, and restarted the server but that is not working.

回答1:

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.

回答2:

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?

回答3:

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.

回答4:

I got this error when I (deliberately) reduced the configuration of maximum SQL Server memory to 16Mb and restarted.

So it might be a memory issue.

回答5:

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

回答6:

I encountered this problem when the password for the login that I was attempting to connect with had expired.

回答7:

I assume you have seen this: http://technet.microsoft.com/en-us/library/ms175496.aspx

how about this? http://blogs.msdn.com/sql_protocols/archive/2006/07/26/678596.aspx

回答8:

1st check the Window's Event Log for the following error:

Could not connect because the maximum number of ’1′ user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed.

To solve the problem do the following:

• Open Microsoft SQL Server Management Studio
• Open a new query

• Type the under given code and press the execute button

  sp_configure ‘show advanced options’, 1;
  GO
  reconfigure
  GO
  sp_configure ‘user connections’, 0;
  GO
  reconfigure
  GO
  

Source: http://www.windowstechupdates.com/microsoft-sql-server-error-233-no-process-is-on-the-other-end-of-the-pipe/

回答9:

In my case make sure that your connection string has ;password=

回答10:

One another reason for this error message could be the case when you've deleted the database your application uses, and you didn't run the following commands from your visual studio:

Add-Migration MigrationNameHere
Update-Database