I have am trying to write an ASP page that pulls data from a SQL Server database, where the SQL server is on a different machine than the IIS server.
I have everything working, except when a non-administrator goes to my page, they get an error message stating:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I am using intergrated authentication only. I have read about some other people with simmilar problems, and one stated that the problem goes away if you run the IIS and SQL server on the same box. I would like to avoid having to do this.. And it would seem like I could, as, like I said, the page opens and displays just fine for me, but not for the users.