Unable to use Domain Account in IIS to remote SQL Server

[Ovatvvon]

Hi All,

I have IIS running my website on a dev server that also has SQL Server running on the same box. (We'll call it DEV01). Everything works fine there. I have the Anonymous ID set to a Domain Account. It is able to use that account to access the database, as well as databases on remote SQL Servers.

When I moved this to a new (VMware) Production box (We'll call it PROD01), where the database (SQL Server) resides on a remote machine (not the local web server), I keep getting the following error:

[COLOR=red]
Microsoft OLE DB Provider for SQL Server error '80040e4d' 

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 

/_includes/script_header.asp, line 47 [/color]

For testing purposes, I set it up so it would connect to the SQL Server on the DEV01 box, but I get this error. So it isn't a problem with SQL Server, or any security settings there. It to be some setting on the PROD01 web server.

My setup with PROD01 is having the following:

Enabled Anonymous Access
  - Domain Account with Access to Remote SQL Server boxes
Enabled Integrated Windows Authentication

This is the same setup that I had for the website & IIS on the DEV01 box.

Does anyone know what could be causing the problems on this new box?


-Ovatvvon :-Q