Post reply

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

  • January 19, 2009 at 10:34 am

    #204159

    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.

  • February 14, 2009 at 2:12 pm

    #944155

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply