Connecting to SQL 2000 database with SQL 2005 tools installed

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?

"Neil Paddock" wrote:
> 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.
>

Share This Page

Welcome to The Coding Forums!

Welcome to the Coding Forums, the place to chat about anything related to programming and coding languages.

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask questions about coding or chat with the community and help others.
Sign up now!