Can connect to SQLServer from windows app, not from web app

Discussion in 'ASP .Net' started by jhcorey@yahoo.com, Aug 2, 2005.

  1. Guest

    We recently had to repair our SQLServer and a new C drive was put in
    and SQLServer 2000 sp3 re-installed. The data files were on another
    drive and I attached them.

    Now I can do everything except connect from an ASP.NET app. I can
    connect using a windows app from my server, but if I copy the exact
    same data access code to a web app (both running on my machine) I get
    the 'SQLServer does not exist or access denied' message.
    My connection string looks like this:
    "server=LabServer;uid=myUser;pwd=myPwd;database=myDB")

    I can connect through server explorer in VS. I connect with Enterprise
    Manager and Query Analyzer no problem. It's just ASP.NET, and I can't
    see anything different in the code.

    Thanks for any ideas,
    Jim
     
    , Aug 2, 2005
    #1
    1. Advertising

  2. Guest

    Nevermind. It appears to be a DNS problem. Windows server was
    re-installed and the ip address was not correctly assigned. I found I
    could connect to the SQLServer using the ip address but not the name,
    although the name worked in the windows app.

    J
     
    , Aug 2, 2005
    #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. Papa_K

    connect to sqlserver?

    Papa_K, Oct 20, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    332
    Cowboy \(Gregory A. Beamer\)
    Oct 20, 2003
  2. Otis Mukinfus
    Replies:
    3
    Views:
    935
    Juan T. Llibre
    Jul 8, 2005
  3. yoshitha

    not able to connect to sqlserver

    yoshitha, Jan 5, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    437
    yoshitha
    Jan 5, 2006
  4. Javier

    Connect to SQLServer

    Javier, Jan 19, 2005, in forum: C++
    Replies:
    0
    Views:
    322
    Javier
    Jan 19, 2005
  5. =?Utf-8?B?SmVmZnJleQ==?=

    Upgrading ASP w/SQLserver 2000 to ASP.NET w/ SQLserver 2005

    =?Utf-8?B?SmVmZnJleQ==?=, Apr 6, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    501
    sloan
    Apr 27, 2007
Loading...

Share This Page