Wednesday, June 25, 2008

Using SSRS Reports in SharePoint integrated mode with Custom Authentication

Just sharing the problem that we faced while deploying SSRS reports on SharePoint.
SSRS was configured in SharePoint integrated mode with form based authentication. While trying to access reports from report viewer webpart we got following error:
Object moved Object moved to here

This issue was fixed after applying SQL Server hotffix http://support.microsoft.com/kb/939942

When we extended default zone to Internet zone with FBA we got following error:
"The specified path refers to a SharePoint zone that is not supported. The default zone path must be used."
After googling found that SSRS SharePoint integrated mode works only with default zone and it is not supported on any other zones (Intranet, Extranet or Custom).
Following blog has more details on this problem:
http://www.sharepointblogs.com/nrdev/archive/2007/06/21/ssrs-in-sharepoint-2007-site-using-forms-based-authentication-sharepoint-integrated-mode.aspx

1 comment:

Unknown said...

Here is the solution that will solve the default zone issue.
http://praveenbattula.blogspot.com/2011/08/customize-reportviewerwebpart-in-c-and.html