Login failure accessing reportserver

Daniel Savage [MSFT]

2008-09-05 17:50:04 UTC

Looks like perms issue and you have SSRS set to Anonymous access.

Check out the SSRS help at
http://www.microsoft.com/sql/technologies/reporting/default.mspx
--
http://blogs.technet.com/momteam

-------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
-------------------------

Post by Justin Braegelman
I running into this error on my local web server, accessing my report server.
A lot of issues have come up with asp.net chaning in IIS, but I haven't seen
permissions change.
Login failed for user 'RCCWEB3\IUSR_RCCWEB3'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Login
failed for user 'RCCWEB3\IUSR_RCCWEB3'.
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
[ReportServerException: Login failed for user 'RCCWEB3\IUSR_RCCWEB3'.]
[ReportServerException: Cannot create a connection to data source
'DynamicSource'. (rsErrorOpeningConnection)]
[ReportServerException: An error has occurred during report processing.
(rsProcessingAborted)]
Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1
parameters) +743
Default2.Page_Load(Object sender, EventArgs e) +16039
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436