SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to install 2005 Analysis Services to an existing cluster group with SQL Server 2005


How to install 2005 Analysis Services to an existing cluster group with SQL Server 2005

Author
Message
wkatwork
wkatwork
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
carlos.sfc
carlos.sfc
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
Points: 41 Visits: 423
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search