Announcement

Collapse
No announcement yet.

SQL Authentication

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Authentication

    Hi,

    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?

    Cheers

    P

  • #2
    you can try this solution from Steve Thompson http://www.derkeiler.com/Newsgroups/...4-06/0579.html or this http://geekswithblogs.net/ranganh/ar.../25/40489.aspx
    let us know if it solve the problem
    Good Luck

    Shai

    MCSE 2003+Security;MCSE 2003+Messaging
    HP ASE;HP AIS;HP APS

    So, from me to all of you out there, wherever you are, remember:
    the light at the end of the tunnel may be you. Good Day!

    Comment

    Working...
    X