Sunday, March 11, 2012

add Reporting Services to an existing cluster

We have set up SQL Server 2005 failover cluster with 2 nodes, on Windows 2003. I'm now trying to add Reporting Services. I don't see any documentation for how to do this. Is it similar to adding Analysis Services? If I use this command I'm not sure what to put in several paramaters:

start /wait c:\<path-to-setup>\setup.exe /qn VS=<my-virtual-server-name> INSTALL=RS_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server ADDNODE=n GROUP="Cluster Group" IP="111.11.11.11,<my-virtual-server-name" ADMINPASSWORD=xxxx SAPWD=xxxx INSTALLSQLDIR=c INSTALLSQLDATADIR=c RSACCOUNT=mmm\xxxxx RSPASSWORD=<domain-user-psswd> SQLBROWSERACCOUNT=<mmm\xxxxx> SQLBROWSERPASSWORD=<domain-user-psswd> SQLREPORTING=1

My question are for:

IP: do i just put the virtual ip and name here, or every ip in the node?

INSTALLSQLDIR: is c drive correct here, or what is this?

INSTALLSQLDATADIR: is c drive correct here, or what is this?

RSACCOUNT: is this correct, not in the example in document ms144259 and what should go here?

RSPASSWORD: same as above

SQLBROWSERACCOUNT: what goes here?

SQLBROWSERPASSWORD: same as above

Thanks so much for any help.

I have a erlated question. Would I add Reporting Services like they way you add Integration Services? Using Add/Remove programs? If so, When I try that the choice of Reporting Services is blanked out, not available as a choice to install. How could I get that? Thanks!|||

Reporting Service cannot be installed as a virtual service, i.e., it is not a cluster-component. It can be only installed as a standalone instance. You can add it to an installed instance if that instance does not include Reporting Service. Or you can install it in another new instance. So the command line should be like

start /wait setup.exe /qb ADDLOCAL=RS_Server,RS_Web_Interface INSTANCENAME="xxxxx" RSACCOUNT="<domain\account>" RSPASSWORD="<strong password>" SQLBROWSERACCOUNT="<doemain\account>" SQLBROWSERPASSWORD="<strong password>" RSAUTOSTART=1 SQLBROWSERAUTOSTART=1

See BOL for more information related to command line or template.ini file for more sample command lines.

No comments:

Post a Comment