Solved

SSRS Error

Posted on 2010-09-21
3
559 Views
Last Modified: 2012-05-10
Hello,

I get the below error while accessing the ReportServerURL I am not able to browse Reports also.

http://localhost/reportserver

Im not sure where the login access is being denied. It is SQL 2005 Ent on Win 2k3.


==========================================================================
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Exception of type 'System.Web.HttpUnhandledException' was thrown.
System.Web.Services.Protocols.SoapException: Logon failed. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. at Microsoft.ReportingServices.WebServer.RSCustomAuthentication.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.LogonUser(String userName, String password, String authority) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.ReportingService2005.LogonUser(String userName, String password, String authority)

==========================================================================

Thanks,
0
Comment
Question by:dba2dba
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
almander earned 500 total points
Comment Utility
Do all of the items you need in the "Reporting Services Configuration Manager" application have a green checkbox next to them.

Specifically 'Windows Service Identity"
0
 
LVL 8

Author Comment

by:dba2dba
Comment Utility
Yes, all are Green in  "Reporting Services Configuration Manager"
0
 
LVL 5

Expert Comment

by:almander
Comment Utility
Is this resolved?

If not, is this the only installation of reporting services installed on the machine?
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sql query 7 34
MS SQL Pagination for Complex Query 5 31
SQL Inner Join Vs SubQueries 9 23
SSRS Matrix Grand Total 2 11
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now