SQLServerWiki

“The Only Thing That Is Constant Is Change”

Adding Analysis Services to SQL Server 2005 Cluster

Posted by database-wiki on March 6, 2011

Adding Analysis Services to the existing SQL Server Cluster should be done from the command prompt. It cannot be installed from the GUI, it is a bug.

There is a command in the 2005 BOL, however it is incomplete. Below is the command which we have used and were able to successfully add Analysis Server to the existing SQL Server cluster.

setup.exe /qb VS=AS INSTALLVS=Analysis_Server INSTANCENAME=MSSQLSERVER
ADDLOCAL=Analysis_Server ADDNODE=”BLR3R03-11,BLR3R03-10″ GROUP=”Group 0″
ASCLUSTERGROUP=”LABDC04\SQL2K5″ IP=”172.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=”LABDC04\psslab” SQLPASSWORD=Passw0rd1 AGTACCOUNT=”LABDC04\psslab”
AGTPASSWORD=Passw0rd1 SQLBROWSERACCOUNT=”LABDC04\psslab”
SQLBROWSERPASSWORD=Passw0rd1 ASACCOUNT=”LABDC04\psslab” ASPASSWORD=Passw0rd1

The following note is there in the SQL Server 2005 Books Online.

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.

However, the above note seems to be wrong or bug. We have installed the Analysis Server to the same group where SQL Database Engine is present.

Leave a Reply

Fill in your details below or click an icon to log in:

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

 
%d bloggers like this: