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.