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.
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.
Uninstall the instance of SSAS on nodes that are present in the cluster environment.
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.
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.
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.)
Start the installation of the release version of SQL Server 2008.
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.
Install SQL Server 2008 Service Pack 1 to update the Analysis Services feature that you installed in step 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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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).aspxFor more information about how to view SQL Server 2008 setup log files, visit the following MSDN Web site: