Error 18456 Severity 14 State 11

Last Post 17 Jul 2012 04:42 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

16 Jul 2012 10:08 AM
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.

Thank you
New Member
New Member

17 Jul 2012 04:42 AM
You may need specify valid sql login and pwd in data source.

Acceptable Use Policy