Adding IIS anonymous account

[IS300]

I have SQL Server running on Machine1, while IIS is running on Machine2. I get this message when I load an ASP page linked to a SQL Server database"

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

I found that it is because IIS is passing the IUSR_Machine2 creditials onto SQL Server. How do I setup this account on SQL? They are running on different machines, so I would have to find away to bring the local account from Machine2 over to Machine1.

 

[mrdenny]

To do this you would need a domain account.

If you don't have a domain, it might work if you create a matching account on Machine1, with the same password as the account on Machine2.

Make sure to setup IIS not to control the password.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.