Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Unanswered: Login failed for user NT AUTHORITY\ANONYMOUS LOGON

    Microsoft OLE DB Provider for SQL Server error '80040e4d'
    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    My infrastructure is a sql 2008 server (machine name: SRVSQL) and a Windows 2008 server with IIS 7 (machine name: SRVIIS), both in a domain "dominio.lan".

    What I am trying to do is using the machine with IIS and try to connect directly to SQL through windows authentication, and I get the error above.

    I already use the "setspn srvsql", which is:

    MSSQLSvc/srvsql.dominio.lan:1433
    MSSQLSvc/srvsql.dominio.lan

    I'm trying to login with my user and I can't do it, if I install IIS 7 on the server srvsql it works, the user 'util1' has permissions at the database, What am I doing wrong? Do I need to give permissions to "util1" using setspn (which duplicate keys when I do setspn -X)?

    Thanks for your help,

    António Neto

  2. #2
    Join Date
    Oct 2006
    Posts
    2
    Have you enabled the ability to the account/service to delegate in active directory?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •