Skip to Content
0
Former Member
Sep 11, 2008 at 11:54 AM

Unable to connect after migrating from SQL Server 2000 to SQL Server 2005

51 Views

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.