Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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.

↑ 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.

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.

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

↑ Back to the top

Keywords: kb, kbtshoot, kbentirenet, kbexpertiseinter, kbprb, kberrmsg, sql2008relnote, sql2008relnoteconfiguration, sql2008relnoteinstallation, sql2008relnotereadfirst

↑ Back to the top

Article Info
Article ID : 956427
Revision : 5
Created on : 8/19/2020
Published on : 8/20/2020
Exists online : False
Views : 94