Connecting to SQL Server 2000

Discussion in 'ASP .Net' started by =?Utf-8?B?QW5keQ==?=, Apr 16, 2004.

  1. I am trying to connect to SQL Server 2000 from asp.net and I keep getting an error "Login failed". Everything is working fine in test server but the production server is having a problem Test SQL is 7.5 abd production SQL is 2000
     
    =?Utf-8?B?QW5keQ==?=, Apr 16, 2004
    #1
    1. Advertising

  2. =?Utf-8?B?QW5keQ==?=

    AT Guest

    Check if IIS server has SQL Server Client software installed.

    Or try installing it and check if you can connect from IIS server to SQL
    2000 using Query Analyzer.

    If this works then check if connection string used in ASP is good. Meaning
    it contains password etc.

    --
    _________________________
    Anatoli Trifonov
    Software Developer & Consultant
    Minds are like parachutes - they only function when open.
    --Thomas Dewar

    "Andy" <> wrote in message
    news:...
    > I am trying to connect to SQL Server 2000 from asp.net and I keep getting

    an error "Login failed". Everything is working fine in test server but the
    production server is having a problem Test SQL is 7.5 abd production SQL is
    2000
     
    AT, Apr 17, 2004
    #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. Replies:
    1
    Views:
    2,072
    tdavisjr
    Dec 15, 2005
  2. =?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,036
  3. =?Utf-8?B?TmVpbCBQYWRkb2Nr?=

    Connecting to SQL 2000 database with SQL 2005 tools installed

    =?Utf-8?B?TmVpbCBQYWRkb2Nr?=, May 2, 2007, in forum: ASP .Net
    Replies:
    1
    Views:
    407
    =?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=
    May 2, 2007
  4. Me LK
    Replies:
    3
    Views:
    421
    Sanka Kolitha
    Nov 4, 2007
  5. jackster the jackle

    Connecting to MS SQL Server 2000

    jackster the jackle, Jun 12, 2009, in forum: Ruby
    Replies:
    4
    Views:
    123
    jackster the jackle
    Jun 13, 2009
Loading...

Share This Page