Article ID: 956427 - Last Review: April 8, 2009 - Revision: 4.0

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

View products that this article applies to.

On This Page

Expand all | Collapse all

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.
Back to the top

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.
Back to the top

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.
Back to the top

Method 2

  1. Start the installation of SQL Server 2008 Service Pack 1. When the Setup Support Files feature is installed, exit the SQL Server 2008 Service Pack 1 installation.
  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.
Back to the top

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.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top

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:
http://msdn.microsoft.com/en-us/library/ms191545(SQL.100).aspx (http://msdn.microsoft.com/en-us/library/ms191545(SQL.100).aspx)
For more information about how to view SQL Server 2008 setup log files, visit the following MSDN Web site:
http://msdn.microsoft.com/en-us/library/ms143702(SQL.100).aspx (http://msdn.microsoft.com/en-us/library/ms143702(SQL.100).aspx)
Back to the top
APPLIES TO
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
Back to the top
Keywords: 
sql2008relnotereadfirst sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kberrmsg kbprb kbexpertiseinter kbtshoot KB956427
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

 

Related Support Centers