Monday, August 29, 2011

Clustered SQL 2008 R2 Installation Failure

Installing SQL 2008 R2 on a Windows 2008 R2 cluster can be a challenge!   

An example of the problems experienced during installation is when one of the DBAs from my team had a failed SQL Server clustered installation.  Specifically, SQL Server installed on the initial node, but failed to add itself to the second node of a two node cluster.  Attempts to fix the installation were not initially successful as the process seemed to end after the Microsoft SQL Server Setup program with no further action.

The fix to the problem I performed the following steps:
  • Uninstall Microsoft SQL Server Setup
  • Delete the C:\Program Files\Microsoft SQL Server directory
  • Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server hive
The problem seems to be with the SQL Server Setup program that executes prior to any install or fix of SQL Server 2008.  I'm not sure, but there seems to be residual information from previous install attempts that keep additional install attempts from being successful.  There are a number of articles and blog posts on this subject.....enough of them that this program seems to be problematic for many people.

We also had another issue.  The cluster check failed on the node where we were adding the SQL Server node to the SQL clustered instance.  The cluster check succeeded on the other nodes, so I'm working on the assumption that the cluster is actually fine.  How to get past this cluster check?  Use the undocumented setup option skiprules
Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode
This setup option is referred to in kb953748.

No comments:

Post a Comment