Have spent hours and hours trying to work out what is goin on with this issue and i still cant figure it out.
Hopefully someone here will be able to help.
A few details to start with...
Win Server 2003 x64
SQL Server 2008
SQL RS 2008
Server B is scaled out and joined to reportserver DB of Server A.
ASP on both servers. Some apps only run on server B
Server B IIS workgroup ID is running under a domain account.
Kerberos Authentication is enabled.
I am showing intermittant errors in the RS logs stating that a connection cannot be made to a particular database, using login 'NT AUTHORITY\ANONYMOUS LOGON' even though anonymous logons are disabled in IIS.
SQL Server logs state this error as....
Date 19/05/2011 11:11:36
Log SQL Server (Current - 19/05/2011 11:11:00)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access
View Complete Post