When I attempt to execute a report from a SSRS website in native mode, it returns an error 18456, Severity 14, State 11 error in the SQL Server logs.
The error message is "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors."
The website returns "An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Imaging_Test_SQL'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors "
The logfile on the Reporting Services server has an error "Cannot create a connection to data source 'Imaging_Test_SQL'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY/ANONYMOUS LOGON'.
The user that is accessing the site is a member of all of the predefined roles, is a system adminstrator on the site, and has db_datareader rights to the database in question.
Any help would be appreciated.