All geek questions in one place

SQL Server 2008 Reporting Services in a Failover Cluster

When I try to install Reporting Services in the second node of a failover cluster, I get the following error message:

Failed to execute the existing instance with clustering or using the cluster. The instance selected for installation is already installed and grouped in node 2.

But we never installed it before. Does anyone have any ideas? This is on a Windows 2008 64-bit server.

+3
source share
3 answers

Only one. You need to install Reporting Services using Enterprise Edition tools, and avoid using all kinds of nasty things for licensing, as well as for a failover cluster. If you try to do this using standard SQL Server media, you cannot install SSRS in a “shared database”, and the encryption information in the database created by instance # 1 will mercilessly explode into oblivion. This will cause SSRS instance 1 to not work while instance 2 is running (on the second server). Trying to fix this will only turn the situation around.

Personally, I think this is pretty cheating from Microsoft, as it actually means that you need to weigh the cost of Enterprise Edition against the Reporting Services HA permissions.

, Enterprise Edition, , .

+2

-, SQL Server node . , . . Reporting Services.

0

Source: https://habr.com/ru/post/1697718/

More articles:


All Articles