August 9 2010

Installing SQL Server 2005 on a Windows Server 2008 R2 Cluster fails



----------------------------------------------------------------------------
I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.

----------------------------------------------------------------------------

We had an interesting problem on a recent project where SQL Server 2005 wouldn’t install on a Windows 2008 R2 failover cluster.
 
The cluster validates properly however when installing SQL Server 2005, the install ¬†threw an “User has cancelled the installation” error. ¬†The logs showed that communications to the remote node were failing:
 

Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.

The fix is outlined below:

  1. Make sure the task scheduler service is running on the remote cluster node. If the task scheduler service is a cluster resource, fail that resource over to the remote node.
  2. Open regedit and go to HKLMSystemCurrentControlSetControlLSA and change the “disabledomaincreds” from 1 to 0 on all clusters nodes, then reboot all nodes.

 
 



----------------------------------------------------------------------------
I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.

----------------------------------------------------------------------------

Category: Windows | LEAVE A COMMENT