Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkenny
Starting Member
2 Posts |
 Posted - 2009-01-19 : 13:08:22
|
| 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wkenny
Starting Member
2 Posts |
Posted - 2009-01-19 : 14:02:13
|
| Thanks Tara,Option 1 is not really on option in this case. I am looking to add Analysis Services to the same group, physical disk, etc..Can this be done manually (as was the case with SQL 2000 version)? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nimesh.mathews
Starting Member
2 Posts |
Posted - 2010-01-07 : 05:05:11
|
| I have found another way to add Analysis services to the existing SQL cluster group without using new ip,disk and network name by using the following command line script. But this is not recommended for a production box>setup.exe /qb VS=AS INSTALLVS=Analysis_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=Analysis_Server ADDNODE="Testnode1,Testnode2" GROUP="Group 0" ASCLUSTERGROUP="TESTDC\SQL2K5" IP="112.23.84.127,Public" ADMINPASSWORD=Passw0rd1 INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\" INSTALLSQLDATADIR="S:\Program Files\Microsoft SQL Server\" INSTALLASDATADIR="S:\Program Files\Microsoft SQL Server\" SQLACCOUNT="TESTDC\sqllab" SQLPASSWORD=Passw0rd1 AGTACCOUNT="TESTDC\sqllab" AGTPASSWORD=Passw0rd1 SQLBROWSERACCOUNT="TESTDC\sqllab" SQLBROWSERPASSWORD=Passw0rd1 ASACCOUNT="TESTDC\sqllab" ASPASSWORD=Passw0rd1 Description of some of the parameters that will be different at your end are as follows. VS=AS (SQL Virtual server Name)INSTALLVS=Analysis_Server INSTANCENAME=MSSQLSERVER (SQL instance name for default it is MSSQLSERVER)ADDLOCAL=Analysis_ServerADDNODE="Testnode1,Testnode2" (Node Names)GROUP="Group 0" (SQL Group)ASCLUSTERGROUP="TESTDC\SQL2K5" (New Domain Group for Analysis Services must be created before setup)IP="112.23.84.127,Public" (IP same as SQL and Network Name )ADMINPASSWORD=Passw0rd1 (Logged in account password)INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\" (SQL binaries directory)INSTALLSQLDATADIR="S:\Program Files\Microsoft SQL Server\" (SQL Data File Directory)INSTALLASDATADIR="S:\Program Files\Microsoft SQL Server\" (AS Directory)SQLACCOUNT="TESTDC\sqllab" SQLPASSWORD=Passw0rd1AGTACCOUNT="TESTDC\sqllab" AGTPASSWORD=Passw0rd1SQLBROWSERACCOUNT="TESTDC\sqllab" SQLBROWSERPASSWORD=Passw0rd1ASACCOUNT="TESTDC\sqllab" ASPASSWORD=Passw0rd1 |
|
|
|
shan
Yak Posting Veteran
84 Posts |
Posted - 2010-01-07 : 09:51:28
|
| Is the process of AS cluster installation similar to that of database installation? how about reporting service installation in cluster. I have dont multiple installation of db in cluster but never had to do AS \ RS installation in cluster.-Shan |
|
|
|
|
|
|
|
|
Install AnalysisServices to existing cluster group