SQL Server 2008 R2 升级到 Service Pack 3后Report Builder启动不了

    一同事将测试服务器从SQL Server 2008 R2 SP2升级到了SQL Server 2008 R2 SP3后发现Report Service的报表编辑时启动不了Report Builder，错误信息如下所示：

搜索了一下资料，居然发现官方有资料介绍了这个问题：Report Builder of SQL Server 2008 R2 Service Pack 3 does not launch.

We have discovered a problem with Report Builder that ships with SQL Server 2008 R2 Service Pack 3.

If you installed SQL Server 2008 R2, have upgraded it to Service Pack 2 and then applied Service Pack 3, then Report Builder will fail to launch. It will raise the following error.

ERROR SUMMARY

Below is a summary of the errors,
details of these errors are listed later in the log.

* Activation of http://.../ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application resulted in exception. Following failure messages were detected:

+ File,
Microsoft.ReportingServices.ComponentLibrary.Controls.dll, has a different computed hash than specified in manifest.

We are not planning to release a fix for this issue. Instead we recommend you implement one of the following workarounds.

    - Client side workaround:

        - Install and run Report Builder 3.0 of SQL Server 2008 R2 RTM from the following location:http://www.microsoft.com/en-pk/download/details.aspx?id=6116

        - Or install and run Report Builder of SQL Server 2014 from the following location: http://www.microsoft.com/en-us/download/details.aspx?id=42301

    - Server side workaround:

        - Uninstall Service Pack 3 then uninstall Service Pack 2 and then reinstall Service Pack 3.

We acknowledge the inconvenience. Apologies for this.

Also, we are in the process of:

    - Updating the SQL Server Release Services Blog post announcing the release of SQL Server 2008 R2 Service Pack 3 to add a note to proactively inform customers.

    - Updating the download page of SQL Server 2008 R2 Service Pack 3 to add a note to proactively inform customers.

    - Creating and publishing quickly a dedicated KB article about this issue.

    - Responding to the two MSConnect items that we are aware of about this issue: 1001935 and 1001699.

Regards.

Jean-Yves Devant

Senior Program Manager - SQL Server.

 

官方解释不打算修复这个问题（真是坑爹），它建议执行下面两个解决办法：

   

1： 客户端

     从链接http://www.microsoft.com/en-pk/download/details.aspx?id=6116下载安装SQL SERVER 2008 R2 RTM的Report Builder 3.0

     或者从连接http://www.microsoft.com/en-us/download/details.aspx?id=42301限制安装SQL SERVER 2014的Report Builder。

2：服务器端

       卸载SP3，然后卸载 SP2，然后从新应用SP3来解决问题。