Connecting to SQL 2000 database with SQL 2005 tools installed

G

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top