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

Article translations Article translations
Article ID: 956427 - View products that this article applies to.
Expand all | Collapse all

On This Page

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:
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

Properties

Article ID: 956427 - Last Review: May 16, 2010 - Revision: 5.0
APPLIES TO
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
Keywords: 
sql2008relnotereadfirst sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kberrmsg kbprb kbexpertiseinter kbtshoot KB956427

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com