Well… After working through this one with MS 24x7 Support… they admitted that there still is a bug in the works that prevents you from being able to install RB2ClickOnce.msi directly…. SO… CU3 for SQL 2k8 is still a valuable hotfix with several SSRS tie-ins… (Be aware that as of July 28, 2009 http://support.microsoft.com/kb/972068/ will likely not fix your issue… (i.e. RB2ClickOnce will NOT find SharePoint Plug-in for SSRS as it is looking for it in the wrong place (i.e. the 32 bit location, not the 64 bit location)) and it will refuse to install.
- Side Note on Installing the SSRS SharePoint Plug-in… After SSRS has been installed in integrated mode, you need to install the SSRS SharePoint plug-in across all your Front End Web Servers (Note: there are many sites that advise how to do this…Click Here for example) should you run into issues installing this you should open a cmd prompt and try:
- msiexec /i SharePointRS.msi SKIPCA=1
From the directory where you downloaded the Plug-in which will unpack this to the %temp% directory
- Next use this command: cd %temp%
which will take you to the location of the temp directory on your system
(Note: on my x64 2k8 windows servers this was a directory called “2” [i.e. “C:\Users\JAMESF~1\AppData\Local\Temp\2”. In order to locate the file I needed, I had to navigate up one level to the “C:\Users\JAMESF~1\AppData\Local\Temp” directory).
- Next use this command: rscustomaction –i
Which will install the SharePoint Plug-in files on your system.
(Note: should you examine the output in the cmd window on each machine, to ensure that it ran sucessfully, if not, fix the error and then run it again (also, do NOT run this simultaneously across multiple machines, instead run this command on one machine, wait for it to finish and then move to the next machine)).
- After the install, run through configuration of this from Central Administration > Application Management >Reporting Services section (configure: Grant database access, then Manage integration settings, then Set server defaults). On Set server defaults, make certain to add /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to the Custom report Builder launch URL setting…)
Once you have installed the Moss plug-in the fun begins…
You try to install the RB2ClickOnce.msi file and receive an error stating that you cannot install this as the SSRS SharePoint plug-in has not been installed…
Therefore, you still need to utilize the workarounds found here (Note: you need to click on the “view or add” link in the Workarounds column; Pay attention to the workarounds posted by “RiccardoG on 5/29/2009” and “Surabhi@JLL on 6/23/2009” as both need to be performed to install this feature.
(Note: for your convenience I have taken the liberty of creating this .mst file using the method described in the blog and have provided it and a .bat file to run it. You may download it from
. Once you download this run it (self extraction rar file) to extract the .mst and .bat files in the same location you have your RB2ClickOnce.msi and then double-click on the .bat file to execute these from your Front End Web Servers.)
Once you have performed this workaround make sure to copy all the files from the “C:\Program Files (x86)\Common Files\Microsoft Shared\12\ISAPI\ReportBuilder” directory into the “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI\ReportBuilder” directory (no files will be over-written… they are all new items) on each of your Front-End Web Servers.
You should now be able to utilize the Report Builder 2.0 Click once Technology (assuming that you set the “Custom Report Builder launch URL” in Central Administration)