We have onne SQL server S and two IIS servers E and J and two service a/c for both E\srvaccount and J\srvaccount, respectively. Same rights are provided to both on IIS side as well as SQL Server side. DSN connections are fine in both IIS servers. But the reports are running fine from IIS server E and not from J. Its showing the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
/DPCScripts/agents/conv.asp, line 128.
Please suggest.