尝试缓存
http://blogs.technet.com/b/rob/archive/2010/02/11/caching-ssrs-reports-for-performance.aspx
...我明白我需要设置处理选项：
http://msdn.microsoft.com/en-us/library/ms178821.aspx
...这似乎表明这里应该有一个下拉菜单：
但是，请注意我将鼠标悬停在上面，但没有任何反应。
这是否与我之前安装的具有高级服务的 SQL Express 2008 R2 在升级到 SQL Server Enterprise 时无法完全升级所有用户选项有关？我知道 Express 无法根据文档缓存报告 - 但我现在正在使用 Enterprise。
或者我只是找错地方了？
基本上，SSRS 报告服务器页面（参见上图）仍然是残缺的 Express 版本 - 因此该部分的升级一定失败了。我尝试备份实例，完全卸载 SQL Server 及其所有组件，然后从头开始重新安装。还是没有爱。到底是怎么回事？
Attempting to cache my SSRS reports as referenced in
http://blogs.technet.com/b/rob/archive/2010/02/11/caching-ssrs-reports-for-performance.aspx
...I am to understand I need to set the processing options:
http://msdn.microsoft.com/en-us/library/ms178821.aspx
...which seems to dictate there should be a dropdown here:
However, notice I hover over and nothing happens.
Could this be related to my previous installation SQL Express 2008 R2 with Advanced Services somehow failing to fully upgrade all the user options back when I upgraded to SQL Server Enterprise? I understand Express does not have the ability to cache reports per the documentation - but I am using Enterprise now.
Or am I just looking in the wrong place?
Basically, the SSRS Report Server page (See above Image), is still the crippled Express version - so the upgrade must have failed on that part. I tried backing up the instance, fully uninstalling SQL Server and all it's components, and re-installed from scratch. Still no love. What is going on?
发布评论
评论（2）
我有类似的事情。我相信我通过在 IIS 下设置 SSRS Web 解决了这个问题？这是 SSRS 设置过程中的一个选项。
它使我能够更好地控制网站配置，并且我能够在重新安装之前手动将其删除。
I had something similar. I believe I solved it by setting up the SSRS web under IIS? It's an option during the SSRS setup.
It gave me more control over the website configuration and I was able to manually remove it before re-installation.
回答：即使您从控制面板“卸载”SSRS>卸载程序时，您还必须执行以下操作：
从 SQL Server 手动删除/备份数据库 ReportServer 和 ReportServerTempDB。如果我们已经将一些报表部署到 Reporting Services，我们将备份数据库并在新安装后重新连接。如果我们想设置一个没有报表的干净的 Reporting Services，我们可以使用 Management Studio 删除它们。
从 IIS 中手动删除虚拟文件夹 Reports 和 ReportServer（这仅适用于 RS 2005。您可能知道，RS 2008 不使用 IIS）
手动删除 Reporting Services 实例的文件夹（例如对于 RS 2008 类似于 C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER)。该文件夹不会自动删除，如果我们不手动删除它，配置文件将包含有关旧配置的信息，如果它们存在，我们可能会保留旧问题。
Answered: Even if you "Uninstall" SSRS from the Control Panel > Uninstall a Program, you must also do the following:
Manually remove/backup the databases ReportServer and ReportServerTempDB from the SQL Server. If we already had some reports deployed to Reporting Services, we would do a backup of the databases and reconnect after the new installation. If we want to set a clean Reporting Services without reports, we can just remove them using Management Studio.
Manually remove the virtual folders Reports and ReportServer from IIS (This is only for RS 2005. As you may know, RS 2008 doesn’t use IIS)
Manually remove the folder of the instance of Reporting Services (For example for RS 2008 would be something like C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER). This folder is not removed automatically and, if we don’t remove it manually, the configuration files will contain information about the old configuration and we might conserve old problem if they existed.