Connecting to SQL 2000 database with SQL 2005 tools installed

[Guest]

Using asp.net in Visual Studio 2005, we are getting an error message when
trying to connect to an existing SQL 2000 database.. This has only hapenned
since we installed the SQL 2005 client tools.

The error is:

"An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)"

We are not trying to connect to a SQL 2005 server? - Does anyone know what I
can do to fix it?

Many thanks,
Neil Paddock.

 

[Guest]

Can you post some sample code? You should be able to use the SqlClient
classes to connect to a SQL 2000 database without any issues.
Peter