var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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:
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,
Have you enabled the ability to the account/service to delegate in active directory?