PS 2007 Installation - Data analysis reports configuration

[Arun]

Hi,
Is there is any procedure to configure the data analysis reports where
the SQL server 2005 is installed in a clustered environment.

Thanks in advance,
arun

 

[Gordon]

Are you talking about coniguring PS 2007 Data Analysis for SQL 2005 ? If yes
then you will need to following the procedure documented here.

http://technet.microsoft.com/en-us/library/cc197552.aspx

When you come to the secion of configuring SQL Analysis 2005. Please follow

Option 2: Create the repository by creating a SQL Server 2005 database

Option 1: unfortunately does not work in a cluster.

Hope this helps.

 

[Arun]

Hi Gordon,
Thanks for your reply. You meant to say that it is not possible to setup
the data analysis report when the sql server 2005 installed in a clustered
environment.

Thanks,
arun

 

[Gordon]

Hi Arun,
It is possible to set up Data Analysis iin a SQL 2005 Cluster.
I have setup Data Analysis for PS 2007 in a SQL 2005 clustered environment
successfully.

Please read the procedure outlined in the link below well and follow every
step outlined. You will need to follow Option 2: Create the repository by
creating a SQL Server 2005 database.