Unable to connect after migrating from SQL Server 2000 to SQL Server 2005
We have moved a clients databases from a SQL 2000 instance to a SQL2005 instance.
After attaching the databases everything is working fine on the server client.
However, remote connections are failing with the following error: tcp provider: an existing connection was forcibly closed by the remote host
The surface area configuration of SQL Server 2005 is named pipes only. If we change this to TCP/IP and Named Pipes the SQL Instance shuts down immediately after starting.