Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Business Intelligence > Report Viewing in Sharepoint 3.0 fails
Ask a questionAsk a question
Search Forums:
 

QuestionReport Viewing in Sharepoint 3.0 fails

  • Thursday, November 05, 2009 1:02 PMGreg Rotman Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hello!

    I recently installed Windows Sharepoint 3.0 on a standalone server which also serves as a SSRS 2008 server.  I've deployed a few test reports to the Sharepoint site, but when I try to view the reports I receive this error message:
    • An error occurred during client rendering.
      • The remote server returned an error: (500) Internal Server Error.
    However, if I browse the contents of the report server web service, the report server will render the report correctly.

    I've checked the log and found the below entries:
    library!ReportServer_0-1!1100!11/05/2009-07:55:22:: Call to GetPermissionsAction(http://apps02/Reportsite/Reports/Report1.rdl).
    library!ReportServer_0-1!3a0!11/05/2009-07:55:22:: Call to ListParentsAction(http://apps02/Reportsite/Reports/Report1.rdl).
    library!ReportServer_0-1!1100!11/05/2009-07:55:24:: Call to GetPermissionsAction(http://apps02/Reportsite).
    library!ReportServer_0-1!3a0!11/05/2009-07:55:24:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-1!1100!11/05/2009-07:55:24:: Call to GetPermissionsAction(http://apps02/Reportsite/Reports/Report1.rdl).

    Given the fact that it works correctly using the ReportServer Web Service, and not Sharepoint.  I'm assuming that Sharepoint is the culprit.  After reading the last entry which states a call for retrieving permissions, I can only assume that that is where it is failing.  Has anyone had this problem, and how did you solve it?


    Any help would be greatly appreciated!
     

All Replies

  • Thursday, November 05, 2009 1:13 PMA.m.a.L - aditi.com - Think Product Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Check whether the user logged into sharepoint has necessary permission to view the reports.
     
  • Thursday, November 05, 2009 8:27 PMGreg Rotman Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I've checked Sharepoint permission, and report permission.  Both are full control.  One unusual thing I noticed is the dbo user in SQL Report database had my login info.  But either way it's the same credentials.

    Anyways, its the same username that logs into the sharepoint site as who logs into the ReportServer webservice.  It works under the report service, but not under Sharepoint.

    What other permissions should I look at?  Is there an IIS configuration?  I have allowed ASP impersonation.  Anything else?