Monday, March 19, 2012

Installation Reporting services on SQL fail-over cluster

Hi,
Perhaps a simple question, but I could not find a clear answer in the
deployment guide. I want to install SQL Reporting Services on a SQL fail over
cluster to be used for MOM Reporting. I was wondering where to run the set up
for SRS. Do I run it on the Virtual server or on one (or both) of the nodes?
Does anyone know?
Regards, MartijnIt is best practice to run SQL Server or RS on the CLuster node. In Any case
once you go to the virtual server, you will be directed to the "Physical
Node" that owns the cluster resources. Always use the Virtual Server name to
do anything for RS or SQL Server.
"Martijn" wrote:
> Hi,
> Perhaps a simple question, but I could not find a clear answer in the
> deployment guide. I want to install SQL Reporting Services on a SQL fail over
> cluster to be used for MOM Reporting. I was wondering where to run the set up
> for SRS. Do I run it on the Virtual server or on one (or both) of the nodes?
> Does anyone know?
> Regards, Martijn

No comments:

Post a Comment