Analysis Services 64-bit clustering

In an article in another usenet group, a few months ago, it was
mentioned that MS were developing an updated document for the steps to
cluster the 64-bit
version of Analysis Services.
I'm the tech lead in one of my countries first implementations of
64-bit SQL,
and this has been an issue for us. We've put time into getting the
clustering going, but didn't want to proceed to far down the path
until MS released a supported procedure.
Can anyone tell me if this document has been finalised, and if so when
it will be released?
Cheers,
Reece.
Post a follow
Reece,
A knowledge base article has been written for the clustering Analysis Services 64-bit. Currently it is being reviewed. I don't know when it will become public. I am trying to find out the release date.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Reece,
Guess what? The KB is public today. Here is the link
How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
http://support.microsoft.com/?kbid=308023
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Uttam,
Thanks for this, but I've already seen this article. I'm after one
which explains how to do the clustering with 64-bit Analysis Services.
As this uses SQL Server instead of an Access mdb.
I could get this done myself most likely, but it would involve
registry hacking, and I would rather have a step by step outline from
MS first. Especially when this is for a client site and I need to have
MS support if things go wrong. Which I doubt would be the case when I
tell them I hacked the registry to get this clustering working.
Cheers,
Reece.
uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
> Reece,
> Guess what? The KB is public today. Here is the link
> How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
> http://support.microsoft.com/?kbid=308023
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
|||I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Reece" wrote:

> Uttam,
> Thanks for this, but I've already seen this article. I'm after one
> which explains how to do the clustering with 64-bit Analysis Services.
> As this uses SQL Server instead of an Access mdb.
> I could get this done myself most likely, but it would involve
> registry hacking, and I would rather have a step by step outline from
> MS first. Especially when this is for a client site and I need to have
> MS support if things go wrong. Which I doubt would be the case when I
> tell them I hacked the registry to get this clustering working.
> Cheers,
> Reece.
>
> uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
>
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Uttam Parui[MS]" wrote:

> I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>