Chris Miller Blog

RocketScientist's Miscellaneous Ramblings

Installing SQL Server 2005 on a Windows 2008 R2 Cluster

I just had an interesting issue with an installation I thought I'd share.  I was installing SQL Server 2005 on a Windows Server 2008 R2 cluster.  The cluster validates properly (use the cluster validation tool in 2008 R2, it will save you problems) and failed over properly prior to installation.  When installing SQL Server 2005, I got through putting in all the information and when it came time to actaully install the software got a "User has cancelled the installation" error, and a notification to check the logs.  The logs said:

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.

  Source File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Fri Jul 29 01:13:51 2005
     Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294

The installation was failing when it attempted to attach to the other cluster node.  The resolution is:

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 (the latter was not an issue on my side, I've read questions from people asking about it though).

2.  Go into your registry (insert standard "don't ever edit the registry" disclaimer here) and go to HKLM/System/CurrentControlSet/Control/LSA and change the "disabledomaincreds" from 1 to 0 on EACH CLUSTER NODE and then reboot BOTH CLUSTER NODES.

Then the install worked like a champ.

Big thanks to MS Sql PSS for getting this fixed quickly. 

Legacy Comments


eyechart
2009-12-28
re: Installing SQL Server 2005 on a Windows 2008 R2 Cluster
Thanks for the article, I'll have to add this to our list of sql2k5/win2k8 issues.

We have run into many problems installing SQL 2005 on win2k8 clusters. Kerberos auth (now the default for win2k8 clusters) and installing on systems that have lowercase hostnames (Tara blogged about this a while ago) are a couple other areas that have given us some grief.

btw, here is a KB article that lists some of the issues http://support.microsoft.com/kb/936302 that we have encountered. That KB article is pretty incomplete though.



-ec