Error:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error: 0 – No process is on the other end of the pipe.)

Snapshot:

Workaround 1:

Instead of machine name use IP address

<ipaddress\instancename>

Workaround 2:

Enable Using both TCP/IP and Named Pipes:

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Surface Area Configuration | Configuration for Services and Connections | Remote Connections, choose Local and Remote Connections |Select Using both TCP/IP and Named Pipes | Click Apply

Restart SQL Server RELYONDB & SQL Server Browser service.

Workaround 3:

Enable Using both TCP/IP and Named Pipes:

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager| SQL Server Network configuration| Right Click “Named Pipes” & Click Enable > Right Click “TCP\IP” & Click Enable

Restart SQL Server RELYONDB and SQL Server Browser service.

Workaround 4:

Click Start | Run | type firewall.cpl | Switch Off | Click OK.