I have had nothing but frustration with MOSS 2007 SP2 + SharePoint Reporting Services + SQL 2005 SP2. I even followed Raju Sakthivel's guide to SSRS + SharePoint Integration , but I cannot publish a model when using VS2005.
VS2005 fails to publish after this SOAP call
<ListSecureMethods xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices" /> With the following SOAP exception
<faultstring>The operation is not supported on a report server that is configured to run in SharePoint integrated mode. ---> The operation is not supported on a report server that is configured to run in SharePoint integrated mode.</faultstring> Now according to Microsoft, this is by default which puzzles me
When a report server is configured for SharePoint integrated mode, the ReportService2005 APIs will return an rsOperationNotSupportedSharePointMode error. If the report server is configured for native mode, the ReportService2006 APIs will return an rsOperationNotSupportedNativeMode error.
So,
- how do you publish reports to a report server that is integrated with SharePoint?
- Is it worth integrating it?
- Do you have any success stories?
ps: there is nothing in the supported/unsupported features of this integration that should prevent me from publishing reports. See http://msdn.microsoft.com/en-us/library/bb326290.aspx