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.

 
 

Category: Windows | LEAVE A COMMENT
August 6 2010

Add the classic menu theme to Office 2007 & 2010

After years of using Office 2007 & 2010, sometimes I still wish to go back to the menus of Office 2003 where there were no ribbons. I’ve recently come across a free (for personal use) tool called UBitMenu which allows us to do this.

After downloading the setup from http://www.ubit.ch/software/ubitmenu-languages/ , close all of your Office applications and run the quick setup. Once installed, you will now see a new ‘Menu’ tab in Word, Excel and Powerpoint that will take you back to the familiar menus of Word 2003! Excellent!
 


Word 2010 with the UBitMenu addin installed
Word 2010 with the UBitMenu addin installed

 
 

Category: Geek, Tools | LEAVE A COMMENT
August 5 2010

New Microsoft TS certifications

I’ve spent some time over the last few weeks catching on my Microsoft certifications for some of the areas I focus on and passed the following exams:
 

70-401: TS: Microsoft System Center Configuration Manager 2007, Configuring
70-400: TS: Microsoft System Center Operations Manager 2007, Configuring
70-638: TS: Microsoft Office Communications Server 2007, Configuring

 
This has given me the following certifications:
 
Microsoft Certified Technology Specialist – System Center Configuration Manager (SCCM) 2007: Configuration
Microsoft Certified Technology Specialist – System Center Operations Manager (SCOM) 2007: Configuration
Microsoft Certified Technology Specialist – Office Communications Server 2007: Configuration
 

I found the 70-400 & 70-401 (SCOM & SCCM) exams cover a lot of material and knowledge that you would use in your day-to-day design and administration of these products. I would say that with a few years experience using these products frequently you should be ok to get a passing score. 70-638 (OCS) exam material really went into a lot of depth around design concepts a lot more than day-to-day administration – even if you have used OCS for years I would suggest that you study hard for this one!