Problem With Login Null

Discussion in 'Server Security' started by Riane de Oliveira Torres Santos, Aug 31, 2004.

  1. Hi,
    I have a problem. My web server is a Windows 2k Server and my database
    server a Windows 2003. I use windows authentication to login at SQL Server,
    but when I access from a client machine that uses Win 2k Professional I
    always receive this message: "[Microsoft][ODBC SQL Server Driver][SQL
    Server]Login failed for user '(null)'. Reason: Not associated with a trusted
    SQL Server connection.".
    When I access from a client machine that uses Windows XP everything it´s
    ok.

    This problem only occurs at the web site. When I try to access the Query
    Analyzer or the Enterprise Manager I still have the connection.

    Can anyone help me?!

    Thanks,

    Riane Santos
     
    Riane de Oliveira Torres Santos, Aug 31, 2004
    #1
    1. Advertisements

  2. Are either of your servers domain controllers?
     
    Tim Springston [MS], Sep 1, 2004
    #2
    1. Advertisements

  3. No, only the Win 2k Server, where is the Web Server.

     
    Riane de Oliveira Torres Santos, Sep 2, 2004
    #3
  4. Riane de Oliveira Torres Santos

    Roger Abell Guest

    So then that "no" is actually a "yes, one of the servers is a domain
    controller, the one running IIS webservices" ?

    The web applications is set for anonymous or authenticated access ?
    And, if authenticated, is the web application running in high isolation
    and which types of authentication is it configured to allow?

    --
    Roger Abell
    Microsoft MVP (Windows Server System: Security)
    MCSE (W2k3,W2k,Nt4) MCDBA
     
    Roger Abell, Sep 2, 2004
    #4
  5. The Win2k server has the IIS and the Active Directory.

    Now my dataserver is on a Win 2k server... and the error changed:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
    AUTHORITY\ANONYMOUS LOGON'

    I´m using Windows Authentication, not anonymous

     
    Riane de Oliveira Torres Santos, Sep 3, 2004
    #5
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.