Report Viewing in Sharepoint 3.0 fails

Question

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!

Answer 1

Check whether the user logged into sharepoint has necessary permission to view the reports.

Answer 2

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?