SQL Server 2005 SA login failed. The connection to the server was successfully established but an error occurred during the logon process. Provider shared Memory Provider error 0 There are no processes on the other end of the pipeline.

SQL Server 2005 Express Edition user ' sa ' login failed. The user is not associated with a trusted SQL Server connection. Hint Error: The connection to the server was successfully established but an error occurred during the logon process. Provider shared Memory Provider error 0 There are no processes on the other end of the pipeline.

Solution:

1. First select Server (right-click), Properties---Security server Authentication modified to "SQL Server and Windows Authentication mode"
2, next expand the server under the "Security" folder, "Login"(right-click)SA, expand its Properties window, state-to-login modified to "enabled"

3. After these two steps are done, remember to find the Microsoft SQL server2005-> Configuration Tool->sql Server Surface Area Configurator in the Start menu, click on the "Service and connection surface area Configurator", In the pop-up window, locate the server you are currently logged into, and stop the boot (that is, restart the server) before the SA account can be signed in.

SQL Server 2005 SA login failed. The connection to the server was successfully established but an error occurred during the logon process. Provider shared Memory Provider error 0 There are no processes on the other end of the pipeline.