SQL Server 2008 Error: A connection was successfully made to the server, but a failure occurred during the handshake prior to logon

SQL Server 2008 Connection database today error: A connection was successfully established with the servers, but there was a failure during the handshake prior to logon. When you connect to SQL Server 2008, SQL Server does not allow remote connections under the default settings, which can cause this failure. (provider: Named pipe provider, error:0-no process on the other end of the pipeline.)

At first I thought it was a remote database problem, and tried it, the colleague's machine can connect. The description is my native problem, and then connect to the local database, also reported the same error.

Refer to the http://friendship517.blog.163.com/blog/static/570512782010103084346208/method here to try to solve, or not.

Then I took a careful look at the idea:

1. Check if the SQL Server service is turned on and restart the SQL Server service attempt;

2. View firewall settings,--"firewall off;

3. See that the article concludes with an issue that could be TCP/IP, set IP to Enabled in the TCP/IP properties.

Restart SQL Server service, ok! The database is connected.

SQL Server 2008 Error: A connection was successfully made to the server, but a failure occurred during the handshake prior to logon