A connection has been established with the server, but an error occurs during logon. (Provider: Shared Memory provider, error: 0-there is no process on the other end of the MPs queue .)

This is a problem with the SQL Server 2005 database,

Logon:

A connection has been established with the server, but an error occurs during logon. (Provider: Shared MemoryProgram, Error: 0-No process exists on the other end of the MPs queue .)

Depressed for a long time, finally solved

The solution is as follows:
First, select the server (right-click)> Properties> Security> Server Authentication To "SQL Server and Windows Authentication mode"
Next, expand "security"-> login name-> select the sa Login Account (right-click)-> Status-> login to enable