Problem authenticating Web server in SQL Server

[MarcusH]

Hi,

I'm trying to give my web server domain login permissions on SQL Server which is on a seperate box. I do this by trying to add a login in SQL Server Security with this format DOMAINNAME\IUSR_DOMAINNAME (which is the anonymous username on the web server) as the name, and DOMAINNAME under domain but SQL server says that the domain cannot be found. I'm using Window Authentication.

On the web server, I have an ASP which uses a connection string which does find SQL server, but throws up this error:

"Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Any help on this would be greatly appreciated. Thanks.

Marcus

 

[calidrake]

Did you manually set the IUSR_DOMAINNAME account as the anonymous user in IIS? Also, is the IUSR_DOMAINNAME a local account or a domain account? if it is a local account on a server (which is default) then it will not be able to be authenticated from a remote server. On IIS you actually have to put in DOMAIN\IUSR_DOMAINNAME for the user or else it is a local account. If that is not it, then double check the password.

 

[MarcusH]

Thanks very much for that. That's helped a lot.

Regards
Marcus