A connection to the server was successful but an incorrect resolution occurred during the logon process

A connection was successfully made to the server, but an incorrect solution occurred during the logon process

Prompt when a database is opened

A connection was made to the server successfully, but the solution occurred during the logon process (provider: Shared Memory provider, error:0-no process on the other end of the pipeline). )

　Solution:

1, should be the server does not open pipeline support, see people on the Internet have the same problem, Remote Desktop into the SQL Server server to try:

Open ' programs '-' All Programs '-' Microsoft SQL Server 2005 '-' Configuration Tools '-' SQL Server Configuration Manager ', and in the form that pops up, find ' SQL Server 2005 Network configuration ' and ' "Named pipes" and "TCP/IP" under the MSSQLSERVER protocol, and then restart Microsoft SQL Server 2005

2, open the Configuration tool-> the SQL Server perimeter Application configurator, and after running, select the services and connections perimeter configuration.

First select remote connection-> local connection and remote connection-> use TCP/IP only, click "Apply".

Second, select the service to stop the SQLExpress service before restarting it.