You are currently offline, waiting for your internet to reconnect

You cannot add a cluster node when you install SQL Server 2008 Analysis Services and you do not install the SQL Server 2008 Database Engine

SYMPTOMS
Consider the following scenario:
  • You use Microsoft SQL Server 2008 Setup to install SQL Server 2008 Analysis Services (SSAS) in a cluster environment.
  • You do not install the SQL Server 2008 Database Engine.
  • You try to add a cluster node in the cluster environment.
In this scenario, you cannot add the cluster node. When you view the log file, you see the following entries:
<Date> <Time> Slp: Error: Action "FinalCalculateSettings" threw an exception during execution.
<Date> <Time> Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Value cannot be null.
<Date> <Time> Slp: Parameter name: instanceName ---> System.ArgumentNullException: Value cannot be null.
WORKAROUND
To work around this problem, use one of the following methods.

Note If you do not have SQL Server 2008 Service Pack 1, use Method 1. If you have SQL Server 2008 Service Pack 1, use Method 2 or Method 3.

Method 1

  1. Uninstall the instance of SSAS on nodes that are present in the cluster environment.
  2. In the SQL Server Installation Center, use the Advanced cluster preparation tool under the Advanced option to prepare the cluster installation for all cluster nodes at the same time.
  3. From the active node of the cluster, open the SQL Server Installation Center, and then use the Advanced cluster completion tool under the Advanced option to complete the cluster setup for all cluster nodes.

Method 2

  1. Install SQL Server 2008 Service Pack 1. (This will only update the Setup Support Files. It will not install Microsoft SQL Server 2008 Analysis Services.)
  2. Start the installation of the release version of SQL Server 2008.
  3. On the Feature Selection page of the SQL Server 2008 Setup Wizard, select the Analysis Services feature, and then continue the installation.

    Note Do not select the Database Engine Services feature. You can select other features based on your requirements.
  4. Install SQL Server 2008 Service Pack 1 to update the Analysis Services feature that you installed in step 3.

Method 3

Use the Slipstream feature of SQL Server 2008 Setup to add a cluster node.

The Slipstream feature is introduced in SQL Server 2008 Service Pack 1. This new feature enables you to integrate the base installation with SQL Server 2008 service packs or hotfixes. For more information, see the SQL Server 2008 Service Pack 1 Help file.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
For more information about how to add a node in a SQL Server 2008 failover cluster, visit the following Microsoft Developer Network (MSDN) Web site:For more information about how to view SQL Server 2008 setup log files, visit the following MSDN Web site:
SQL2008RelNote SetupConfigurationSQL2008RelNoteReadFirst"SQL Server 2008 Installation" "SQL Server 2008 Configuration" SQL2008RelNoteInstallation FailoverCluster
Properties

Article ID: 956427 - Last Review: 05/16/2010 04:47:10 - Revision: 5.0

  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • sql2008relnotereadfirst sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kberrmsg kbprb kbexpertiseinter kbtshoot KB956427
Feedback