Microsoft – SQL Server – Adding “Reporting Services” to existing Install (MS SQL Server – v2008/R2)

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):

  1. Went Google
  2. Found Jim Prince’s ( Jim Posterous’s Blog) posting –“http://jimprince.posterous.com/adding-sql-reporting-services-to-existing-clu”
  3. Jim’s original solution is:
 

    setup /q /ACTION=install /FEATURES=RS /InstanceName=MSSQLSERVER 
      /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" 
      /RSINSTALLMODE="FilesOnlyMode"

  1. Setup complained about missing entries:
  2. 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"

 

Dedication

Nice one – Google & Jim

Now I can do the impossible – Go home on time

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s