When I try to install the Reporting Services on a second node of a failover cluster, I get the following error message:
当我尝试在故障转移群集的第二个节点上安装Reporting Services时,收到以下错误消息:
Existing clustered or cluster-prepared instance failed. The instance selected for installation is already installed and clustered on node 2.
现有的集群或集群准备的实例失败。选择安装的实例已安装并集群在节点2上。
But, we never installed it before. Does anyone have any ideas? This is on Windows 2008 server 64-bit.
但是,我们以前从未安装过它。有没有人有任何想法?这是在Windows 2008服务器上64位。
3 个解决方案
#1
2
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.
但只有一件事。您必须使用Enterprise Edition介质安装Reporting Services,并且为避免对许可执行各种讨厌的操作,故障转移群集也必须是Enterprise Edition。如果您尝试使用SQL Server Standard媒体执行此操作,则无法将SSRS安装到“共享数据库”,并且实例#1创建的数据库中的加密信息将被无情地删除。这将导致实例2(在第二台服务器上)工作时SSRS的实例1不起作用。试图解决这个问题只会打破局面。
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.
我个人认为这对微软来说非常糟糕,因为它实际上意味着你必须权衡企业版与支持HA的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.
基本上,如果您不希望Reporting Services成为单点故障,则必须购买Enterprise Edition。
#2
0
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.
显然,SQL Server可以安装在故障转移群集上的每个节点上。需要注意的是,它必须是两个具有两个不同实例名称的独立安装。但是,您可以共享同一个报表服务器数据库。有关部署Reporting Services的详细信息,请阅读本文。
#3
0
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.
考虑一下SSRS横向扩展过程的这篇文章。在群集上安装共享报表服务器数据库。然后安装报告服务以使用共享数据库。报告服务不会故障转移,但数据库会。
This is an option to failover IIS: http://support.microsoft.com/kb/970759
这是故障转移IIS的选项:http://support.microsoft.com/kb/970759
#1
2
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.
但只有一件事。您必须使用Enterprise Edition介质安装Reporting Services,并且为避免对许可执行各种讨厌的操作,故障转移群集也必须是Enterprise Edition。如果您尝试使用SQL Server Standard媒体执行此操作,则无法将SSRS安装到“共享数据库”,并且实例#1创建的数据库中的加密信息将被无情地删除。这将导致实例2(在第二台服务器上)工作时SSRS的实例1不起作用。试图解决这个问题只会打破局面。
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.
我个人认为这对微软来说非常糟糕,因为它实际上意味着你必须权衡企业版与支持HA的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.
基本上,如果您不希望Reporting Services成为单点故障,则必须购买Enterprise Edition。
#2
0
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.
显然,SQL Server可以安装在故障转移群集上的每个节点上。需要注意的是,它必须是两个具有两个不同实例名称的独立安装。但是,您可以共享同一个报表服务器数据库。有关部署Reporting Services的详细信息,请阅读本文。
#3
0
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.
考虑一下SSRS横向扩展过程的这篇文章。在群集上安装共享报表服务器数据库。然后安装报告服务以使用共享数据库。报告服务不会故障转移,但数据库会。
This is an option to failover IIS: http://support.microsoft.com/kb/970759
这是故障转移IIS的选项:http://support.microsoft.com/kb/970759