Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to install 2005 Analysis Services to an existing cluster group with SQL Server 2005 Expand / Collapse
Author
Message
Posted Monday, January 19, 2009 10:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 01, 2012 12:19 PM
Points: 1, Visits: 25
I attempted to install (add) SQL Server 2005 - Analysis services to an existing SQL Server 2005 cluster group and found it did not appear to be possible. Running setup, there were only two options; (1) install a new failover cluster (specifically for Analysis services), new virtual server name, ip address, physical disk, etc...are required or (2) install it as standalone.

Based upon the article below, it appears to be possible, but how?

SQL Server Technical Article - Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services states;

"If you cluster just the SQL Server Database Engine, you can cluster Analysis Services at a different time (and vice versa) and still add it to the same cluster group with SQL Server 2005 if you want. You do not have to add Analysis Services from the start; this allows you to expand your capabilities as your needs for various features within SQL Server change over time.”

Thank you for any information you may have.
Post #639435
Posted Saturday, February 14, 2009 2:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 11:44 AM
Points: 29, Visits: 304
Body,

I have the same problem, I want to add AS to an existing SQL Server DB Cluster. I think that the solution is by this way: http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx

Look at this part:

To add components to an existing, SQL Server 2005 cluster from the command prompt
Insert the SQL Server 2005 installation media into the disk drive.

To add Analysis Services to an existing cluster, use the following syntax:

start /wait INSTALLVS=Analysis_Server
INSTANCENAME=
IP=
INSTALLSQLDIR=
ASACCOUNT=
SQLBROWSERACCOUNT=
SQLREPORTING=1

Note:
You cannot install Analysis Services to the same cluster group as the Database Engine. You must install Analysis Services to its own group and then, after installation, you can move Analysis Services to the same group as SQL Server.
For a complete list of parameters, see Parameters below.
-------------------------------------------------------------------------------

This is the information, but i really have some questions

This create a new cluster with ips and disk resources or really add AS to an exiting sql cluster.


Does any body can help us?
Thanks
Post #657249
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse