Connecting to SQL 2000 database with SQL 2005 tools installed

Discussion in 'ASP .Net' started by =?Utf-8?B?TmVpbCBQYWRkb2Nr?=, May 2, 2007.

  1. 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.
     
    =?Utf-8?B?TmVpbCBQYWRkb2Nr?=, May 2, 2007
    #1
    1. Advertising

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

    --
    Site: http://www.eggheadcafe.com
    UnBlog: http://petesbloggerama.blogspot.com
    Short urls & more: http://ittyurl.net




    "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.
    >
     
    =?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=, May 2, 2007
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ansari
    Replies:
    1
    Views:
    698
    David Lloyd
    May 14, 2005
  2. Replies:
    1
    Views:
    2,083
    tdavisjr
    Dec 15, 2005
  3. Learner
    Replies:
    4
    Views:
    2,128
    Learner
    Jan 27, 2006
  4. =?Utf-8?B?RGVyZWs=?=
    Replies:
    1
    Views:
    2,572
    =?Utf-8?B?RGVyZWs=?=
    Jun 9, 2006
  5. Me LK
    Replies:
    3
    Views:
    434
    Sanka Kolitha
    Nov 4, 2007
Loading...

Share This Page