Today! (Cleaning up Reporting Services SharePoint Add-In Setup Problems)


Some people have had problems during installation of the new Reporting Services Add-in for Microsoft SharePoint. If the add-in setup fails while to add the Reporting Services feature to the sites, some of your SharePoint sites will no longer work.  You can tell if the custom action failed by looking for a file named RS_SP_#.log in your %temp% directory.  If you have a log file there and your install failed, you will need to manually clean up your web.config files to get SharePoint up and running again.


First, you will need to locate the SharePoint virtual directories on your server.  Typically these are located at c:\inetpub\wwwroot\wss\VirtualDirectories. This folder contains several folders with names which are numbers representing the ports used by your SharePoint sites.  In each folder you will need to remove the following entries from the web.config file:


      <SafeControl Assembly=”Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91″ Namespace=”Microsoft.ReportingServices.SharePoint.UI.WebParts” TypeName=”*” />
      <SafeControl Assembly=”Microsoft.ReportingServices.SharePoint.UI.ServerPages, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91″ Namespace=”Microsoft.ReportingServices.SharePoint.UI” TypeName=”*” />
      <add verb=”*” path=”Reserved.ReportViewerWebPart.axd” type=”Microsoft.ReportingServices.SharePoint.UI.WebParts.WebPartHttpHandler, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91″ />
      <add verb=”*” path=”_vti_bin/ReportServer” type=”Microsoft.ReportingServices.SharePoint.Soap.RSProxyHttpHandler, RSSharePointSoapProxy, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91″ />


and


  <location path=”_vti_bin/ReportServiceAuthentication.asmx”>
    <system.web>
      <authorization>
        <allow users=”*” />
      </authorization>
    </system.web>
  </location>


Once you remove these lines, save the file.  You must do this for every web.config file under the above directory.


To get around the issue, you need to add the user who is running setup as one of the Site Collection administrators before you run the setup. You can do this though the Site Adminstration page.


This is a known issue with our CTP2 setup and has been addressed in CTP3.

Comments (14)

  1. Is this THE Brian Welcker?

    If so, ‘Howdy friend.’

    It’s been a long time.

  2. roy says:

    hi

    i want to show the subreport’s page header in the report. how can i do that?

    thanks.

    sorry, i do not konw your e-mail address, so wirte down here….

  3. Steve Sass says:

    I have struggled with this issue for days!!!!!  Adding the user to the site collection admins did not help.  In the log, the last error is:  SSRSCustomActionError: Attempted to perform an unauthorized operation.

    -Very frustrated

  4. Steve Sass says:

    OK….I got past that issue…..and I was so close.  The only thing not working is the content type for the Report Model will no import.  I’ve tried repairing the install, and still no luck.

  5. Bill Wolff says:

    I can’t get throught he install of SharePointRS.msi. It says that SharePoint is not installed, which it is. There are no logs or explanations that I can find. Where do I go to get detailed installation instructions? Is there a newgroup or forum that might help?

  6. gnewcom says:

    I am having a slightly different issue with the Add-In.  It appears to install fine, but then the Reporting Services Section does not show up under Sharepoint Central Administration.  I’ve tried setting up in RS Native mode first, then adding the Add-In – no luck.  I’ve tried installing the Add-In before configuring RS and then configuring RS as "Integrated" mode right out of the box – no luck.  I’m stymied.

    Any suggestions?

  7. After installing the SPS/MOSS &amp; SSRS integration add-in, I surfed to the Application Management page

  8. Yanwen Guo says:

    Brian,

    I can deploy and run report in sharepoint server, but I can not find any report management actions such as Edit in Report Builder, Manage Subscriptions, Manage Data Sources, Manage Parameters and Manage Processing Options, etc. Could you please tell me why and how to fix?

    Thank you very much.

    Yanwen

  9. trevor ct says:

    The installation seems okay but the reporting services section does not come up in the Sharepoint Central Administration tool.

    The RS_SP_x.Log  file reports the following error which is not correct because not only am I logged in as the administrator on the box, but the account has also explicitly been added to the Farm Administrators group and it is the designated Primary Site Collection administrator.

    Any help would be appreciated before I drop RS altogether and start looking for something that at least installs.

    copyappbincontents command completed successfully.

    Adding Report Server feature to farm.

    Report Server feature was already installed.

    Activating Report Server feature to root level site collections.

    Activating feature in web app ‘SharePoint – 80’

    Activating feature to root site collection: http://avapt003

    Feature already activated in site collection http://avapt003

    Activateing Report Server feature in all admin site collections.

    Activating feature in web app ”

    Activating feature to root site collection: http://avapt003:1600

    ******* User does not have permission to add feature to site collection: http://avapt003:1600

    Updating DocIcon.xml file

    DocIcon.xml file updated.

    Beginning install of cab files.

    Calling HCInstal for lcid ‘1033’

  10. Garenovich says:

    trevor ct,

    go to Application Managment -> Site collection administrators, select the administration web application, and verify that your user is ther administrator of the site. Also check in the site that the user has full control (Site Actions -> Site Settings -> People and Groups).

  11. Garenovich says:

    trevor ct,

    I after that reinstall the Add-In.

    That resolves the problem.

  12. r_p says:

    I had the same problem today (so probably not with CTP2, whatever that is) and found several pages on how to resolve it, including this one.  The one that worked is here:

     http://www.venkat.org/2007/06/reporting-services-add-in-reportserver.html

  13. I’ve been running into major problems with this latest attempt to install the RS Add-in (which I have done successfully on several other farms).  This error, which rolls back the installation, reads:

    "Unable to process .Cab file or Help Collection directory.  Cannot perform action."

    Anyone ever seen this one?  There doesn’t seem to be much on the ‘net referring to it.

    Thanks!

    Keith

  14. glas456@hotmail.com says:

    Hi There

    I am using Windwos 2008 X64, SharePoing 2007 X64

    First install using GUI failed, then use the command line

    Execute SharePointRS_x64.msi SKIPCA=1

    CD to %temp%

    Execute rsCustomAction.exe -i

    failed again, then try :rsCustomAction.exe -r  and  -u  

    the result looks like the same,  it always says: Uninstalling Report Server feature.  Uninstalling Report Server feature….  

    Below is my: RS_SP_3.log

    Installing Report Server feature.

    Calling copyappbincontents command.

    One or more types failed to load. Please refer to the upgrade log for more details.

    Install error: C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12binstsadm.exe return error code: -1

    Uninstalling Report Server feature.

    Uninstalling Report Server feature.

    Report Server feature was uninstalled.

    Stopping W3SVC service.

    Removing Report Server web application files

    Removed file E:inetpubwwwrootwssVirtualDirectories80App_GlobalResourcesReportServer.resx.

    Removed file C:inetpubwwwrootwssVirtualDirectories443App_GlobalResourcesReportServer.resx.

    Removed file C:inetpubwwwrootwssVirtualDirectories35774App_GlobalResourcesReportServer.resx.

    Removed file C:inetpubwwwrootwssVirtualDirectories6747App_GlobalResourcesReportServer.resx.

    Removed file C:inetpubwwwrootwssVirtualDirectories41424App_GlobalResourcesReportServer.resx.

    Removed file C:inetpubwwwrootwssVirtualDirectories37405App_GlobalResourcesReportServer.resx.

    Removed file E:inetpubwwwrootwssVirtualDirectories1400App_GlobalResourcesReportServer.resx.

    Removed file E:inetpubwwwrootwssVirtualDirectories17862App_GlobalResourcesReportServer.resx.

    Removed file C:inetpubwwwrootwssVirtualDirectories39208App_GlobalResourcesReportServer.resx.

    Removing DocIcon.xml file updates

    Beginning uninstall of cab files.

    Calling HCInstal for lcid ‘1033’

    Outcome code is: 32

    Calling HCInstal for lcid ‘3082’

    .

    .

    .

    Cab files uninstalled successfully.

    Starting W3SVC service.

    SSRSCustomActionError: C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12binstsadm.exe return error code: -1

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

    and I can’t find below lines in your article so can’t remove them.

    <SafeControl Assembly="Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.ReportingServices.SharePoint.UI.WebParts" TypeName="*" />

         <SafeControl Assembly="Microsoft.ReportingServices.SharePoint.UI.ServerPages, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.ReportingServices.SharePoint.UI" TypeName="*" />

         <add verb="*" path="Reserved.ReportViewerWebPart.axd" type="Microsoft.ReportingServices.SharePoint.UI.WebParts.WebPartHttpHandler, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

         <add verb="*" path="_vti_bin/ReportServer" type="Microsoft.ReportingServices.SharePoint.Soap.RSProxyHttpHandler, RSSharePointSoapProxy, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

    and

     <location path="_vti_bin/ReportServiceAuthentication.asmx">

       <system.web>

         <authorization>

           <allow users="*" />

         </authorization>

       </system.web>

     </location>