SQL Authentication

Home Forums Other Misc SQL Authentication

Viewing 1 post (of 1 total)
  • Author
  • Avatar


    I have a web server (Windows 2003 + SP1) and a database server (Windows 2003 + SP1 + SQL 2000 +SP3a)

    These servers are members of the same Active Directory Domain, the SQL Server is configured to run under a domain account.

    Delegation has been enabled on both Web Server and Database Server, the SPN have been manually configured for the SQL Account running the database server.

    The database instance is running in mixed mode the web site is enable for Intergrated Windows Authentication only.

    Also the web server is set to Negotiate for NTAuthenticationProviders

    However I still have some the following messages appearing in the SQL Log every day:
    Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server Connection.

    This connection shows up as Anonymous in the Security event logs of the database server and can be matched back to the web server where the security event log traps the logon event as being NTLM.

    All connection use kerberos to this website how does the NTLM connection occur every so often?



Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.