August 9 2010

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

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
June 2 2009

Change Product Key On Windows Server 2008

Open the command prompt and navigate to %windir%System32 directory

slmgr.vbs -cpky (this clears the KMS entry you may have)
slmgr.vbs -upk (this removes any product key installed)
slmgr.vbs -ipk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx (where the x’s are the new product key you want to use)
slmgr.vbs -ato (this activates the server)

Type slmgr.vbs for further options….

Category: Windows | LEAVE A COMMENT
January 9 2009

Turn off Internet Explorer Enhanced Security Configuration in Windows Server 2008

After using Windows 2003 for so long, I was used to going to Add/Remove Programs to turn off IE ESC.  It’s different in Windows 2008:

Select the root of the Service Manager navigation pane, and under the Server Summary click Configure IE ESC, which is part of the Security Information section. A dialog box appears, letting Internet Explorer Enhanced Security Configuration be enabled/disable separately for normal users and administrators.

Category: Windows | LEAVE A COMMENT