As always, it was a full \ honest working day in MS SQL Server Orbit.
Tried adding “Reporting Services” to an existing Clustered Install.
First Route tried:
Launched setup from Command Line. Was going through the steps, but ended up in a lately all too likely place:
Rule Check Result
Rule “Existing clustered or cluster-prepared instance” failed.
The instance selected for installation is already installed and clustered on computer CLUSNODE2. To continue, select a different instance to cluster.
Best Route (worked):
- Went Google
- Found Jim Prince’s ( Jim Posterous’s Blog) posting –“http://jimprince.posterous.com/adding-sql-reporting-services-to-existing-clu”
- Jim’s original solution is:
setup /q /ACTION=install /FEATURES=RS /InstanceName=MSSQLSERVER /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /RSINSTALLMODE="FilesOnlyMode"
- Setup complained about missing entries:
- Changed Setup invocation to:
setup /q /ACTION=install /FEATURES=RS /InstanceName=MSSQLSERVER_RS /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /RSINSTALLMODE="FilesOnlyMode" /IAcceptSQLServerLicenseTerms="True" /INSTANCEDIR="E:\Program Files\Microsoft SQL Server"
Nice one – Google & Jim
Now I can do the impossible – Go home on time