Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question