将 Analysis Services 添加到群集 SQL Server 2008 实例
我有一个现有的多实例 SQL 2008 群集，并且我正在尝试将 Analysis Services 添加到现有实例。 我开始安装，选择“添加功能”，配置 SSAS，然后在最后的安装前检查中，“现有集群或集群准备实例”检查失败。 当然，我会失败此检查 - 我正在尝试向现有集群实例添加功能。 这是错误的图片：
（来源：trycatchfinally.net）< /sub>
有人成功地将功能添加到 SQL 2008 中的集群实例吗？ 我不敢相信这是不可能完成的 - 我的替代方案是从一个节点删除 SQL，尝试再次添加该功能，希望我不会失败相同的检查（尽管我可能会失败），然后重新添加到第二个节点。 这看起来很危险而且没有必要。
我发现另一个人有同样的问题，但明确回答的人甚至没有阅读这个问题，因为他们提到如何集群服务器，并且他应该使用 SQL 2000，所以这根本没有帮助（尽管我很乐意在回答后指出他：http://forums. techarena.in/software-development/1209984.htm
I have an existing multi-instance SQL 2008 cluster, and I'm trying to add Analysis Services to an existing instance. I start the installation, pick "Add features", configure SSAS, and then on the final pre-installation check, I fail the "Existing clustered or cluster-prepared instance" check. Of course I'd fail this check - I'm trying to add a feature to an existing clustered instance. Here's a picture of the error:
(source: trycatchfinally.net)
Has anybody successfully added a feature to a clustered instance in SQL 2008? I can't believe it can't be done - my alternative is to remove SQL from one node, try to add the feature again, hoping I don't fail this same check (though I probably will), and then re-add to the second node. This seems dangerous and unnecessary.
I found another person who had the same question, but the people answering it clearly aren't even reading the question, since they're mentioning how to cluster a server, and that he should use SQL 2000, so this is no help at all (though I'd love to point him here once it's answered: http://forums.techarena.in/software-development/1209984.htm
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
查看 SQL Server 2008 故障转移群集白皮书。
http://下载。 microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx
第 31 页 32
》注意：SQL Server 2008 不支持向现有故障转移群集实例添加功能，因此无法将 Analysis Services 添加到现有 SQL Server 实例。要与 SQL Server 实例共享资源组，必须选择安装SQL Server 初始安装期间的 Analysis Services。”
Take a look at the SQL Server 2008 Failover Clustering whitepaper.
http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx
Page 31 & 32
"Note: SQL Server 2008 does not support adding features to an existing failover cluster instance, so Analysis Services cannot be added to an existing instance of SQL Server. To share a resource group with an instance of SQL Server, you must choose to install Analysis Services during the initial installation of SQL Server."
警告：我从未将分析服务添加到现有的集群环境中。
但这就是我的做法：
1. 从集群中删除一个节点（假设您有 > 2 个节点）。
2. 安装分析服务。
3. 将节点带回集群。
Warning: I have never added analysis services to my existing cluster environment.
But this is how i would go about it:
1. Remove one node from cluster ( provided u have > 2 nodes ).
2. Install Analysis services.
3. Bring the node back into cluster.
尝试找到必要的 /skiprules 参数。
我使用以下安装 SQL 命令来通过集群实例安装 SSRS 功能：
Try to find necessary /skiprules parameter.
I have used the following setup SQL command to install SSRS feature with clustered instance:
通过 SQL Server 安装中心运行安装程序或从命令提示符运行安装程序时，不支持添加或删除功能的选项。 有关尝试通过设置添加功能时会发生什么情况的更多信息，您可以参考以下论坛帖子：
可以找到本文 此处。
如果您需要向现有安装添加或删除功能，则需要重新安装具有所需功能的虚拟实例。 有关其他信息，您可以参阅 SQL Server 联机丛书中的以下主题：
注意：SQL Server Analysis Services 资源是安装 Analysis Services 的任何 SQL Server 故障转移群集资源组的一部分。 尽管可以将数据库引擎和 Analysis Services 安装在同一资源组中，但通常建议将它们安装为单独的实例。 Analysis Services 不依赖于 SQL Server，应将其安装到单独的资源组中以获得最大可用性和性能。
The option to add or remove features is not supported either when running the setup through SQL Server Installation Center or when running the setup from a command prompt. For more information on the what happens when you try to add a feature through setup you can refer to the following forum post:
This article can be found here.
If you need to add or remove features to an existing installation you need to reinstall the virtual instance with the required features. For additional information you can refer to the following topics in SQL Server Books Online:
Note: The SQL Server Analysis Services resource is a part of any SQL Server failover cluster’s resource group where Analysis Services is installed. Although it is possible to install both Database Engine and Analysis Services in the same resource group, it is generally recommended to install them as separate instances. Analysis Services is not dependent on SQL Server, and it should be installed to a separate resource group for maximum availability and performance.