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:
The fix is outlined below:
- 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.
- Open regedit and go to HKLM\System\CurrentControlSet\Control\LSA and change the “disabledomaincreds” from 1 to 0 on all clusters nodes, then reboot all nodes.