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

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

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. =?Utf-8?B?QW5keQ==?=

    Connecting to SQL Server 2000

    =?Utf-8?B?QW5keQ==?=, Apr 16, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    423
  2. Ansari
    Replies:
    1
    Views:
    793
    David Lloyd
    May 14, 2005
  3. Replies:
    1
    Views:
    2,184
    tdavisjr
    Dec 15, 2005
  4. Michael
    Replies:
    2
    Views:
    9,260
    magscy
    Jul 19, 2009
  5. Learner
    Replies:
    4
    Views:
    2,395
    Learner
    Jan 27, 2006
  6. =?Utf-8?B?RGVyZWs=?=
    Replies:
    1
    Views:
    2,759
    =?Utf-8?B?RGVyZWs=?=
    Jun 9, 2006
  7. =?Utf-8?B?VG9kZCBCcmV3ZXI=?=

    ASP.NET 2.0 connecting to SQL Server 2000

    =?Utf-8?B?VG9kZCBCcmV3ZXI=?=, Sep 9, 2006, in forum: ASP .Net
    Replies:
    6
    Views:
    7,223
  8. Me LK
    Replies:
    3
    Views:
    573
    Sanka Kolitha
    Nov 4, 2007
Loading...