故障转移群集上的 SQL Server 2008 Reporting Services
当我尝试在故障转移群集的第二个节点上安装 Reporting Services 时，收到以下错误消息：
现有群集或群集准备的实例失败。 选择安装的实例已安装并集群在节点 2 上。
但是，我们以前从未安装过它。 有人有什么想法吗？ 这是在 Windows 2008 服务器 64 位上。
When I try to install the Reporting Services on a second node of a failover cluster, I get the following error message:
Existing clustered or cluster-prepared instance failed. The instance selected for installation is already installed and clustered on node 2.
But, we never installed it before. Does anyone have any ideas? This is on Windows 2008 server 64-bit.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
不过只有一件事。 您必须使用企业版介质安装 Reporting Services，并避免对许可进行各种讨厌的事情，故障转移群集也必须是企业版。
如果您尝试使用 SQL Server Standard 介质执行此操作，您将无法将 SSRS 安装到“共享数据库”，并且实例 #1 创建的数据库中的加密信息将被无情地销毁。
这将导致 SSRS 实例 1 不工作，而实例 2（在第二台服务器上）正在工作。 试图解决这个问题只会扭转局面。
就我个人而言，我认为 Microsoft 的这一做法非常令人失望，因为它实际上意味着您必须权衡企业版与支持 HA 的报告服务的成本。
因此，基本上，如果您不希望报告服务成为单点故障，则必须购买企业版。
Just one thing though. You have to install Reporting Services using the Enterprise Edition media and to avoid doing all kinds of nasty stuff to the Licensing the fail-over cluster also have to be Enterprise Edition.
If you try to do this using the SQL Server Standard media you will not be able to install SSRS to a "Shared Database" and the encryption information in the database created by instance #1 will be mercilessly blasted into oblivion.
This will result in instance 1 of SSRS not working while instance 2 (on the second server) is working. Trying to fix this will only flip the situation.
Personally i find this to be quite the bummer from Microsoft since it practically means that you have to weigh the cost of Enterprise Edition against HA-enabling Reporting Services.
So basically, you have to acquire Enterprise Edition if you do not want your Reporting Services to be the Single Point of Failure.
显然，SQL Server 可以安装在故障转移群集的每个节点上。 需要注意的是，它必须是具有两个不同实例名称的两个单独安装。 但是，您可以共享同一个报表服务器数据库。 请阅读这篇文章，了解有关部署的详细信息报告服务。
Apparently, SQL Server can be installed on each node on a failover cluster. The caveat is that it must be two separate installations with two different instance names. You can, however, share the same report server database. Please read this article for more information on deploying Reporting Services.
http://msdn.microsoft.com/en-us/library/ms159114。 aspx
考虑这篇有关 SSRS 横向扩展过程的文章。 在群集上安装共享报表服务器数据库。 然后安装报告服务以使用共享数据库。 报告服务不会进行故障转移，但数据库会。
这是 IIS 故障转移的选项：http://support.microsoft.com/kb/970759
http://msdn.microsoft.com/en-us/library/ms159114.aspx
Consider this article on SSRS scale out process. Install the shared report server database on the cluster. Then install reporting services to use the shared database. Reporting services will not failover, but the database will.
This is an option to failover IIS: http://support.microsoft.com/kb/970759