Hi,

Yesterday I successfully deployed all the OCS 2007 R2 updates on my OCS 2007 R2 server using the Cumulative Installer, which was a fantastic experiences. The installer only installs the updates required for your server role.

Afterwards I ran the OCS2009-DBUpgrade.msi package to upgrade the OCS 2007 R2 database which failed with an unexpected error. This is what I found in the setup log file (in your %temp% folder)

Updating SE server database stored procedures. This will take a while ...
cscript dbsetup.wsf /SqlServer:(local)\rtc /Role:se /Verbose
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

Installed SQL Server 2005 Backward Compatibility version is 8.05.2004
Connecting to SQL Server on (local)\rtc

Error attempting to validate the SQL server: reconfigure statement failed. This SQL instance has pending configuration changes that need to be resolved before installation can continue.

I looked around on the web but couldn't find anything related to it with the exception of one blog posting recommending to run the "reconfigure statement" using the SQL management studio tool using an account with the SQL sysadmin right. Unfortunately on a OCS 2007 R2 Standard Edition server you have SQL 2005 Express Edition installed where you don't have an account with sysadmin rights.

So I decided to put up a posting on Technet Forums and not soon after I received a suggestion to run the MSI package from within an elevated command prompt. And yes indeed this is what had to be done, open a command prompt as Administrator and execute the MSI package from within. I obviousely was running OCS 2007 R2 on Windows 2008 and hence the UAC got in the way of deploying this update which didn't seem to bother the Cumulative Installer.

Kudos to Mark King for his help on this (http://social.technet.microsoft.com/Forums/en-US/ocsplanningdeployment/thread/9bf670a4-2888-4474-8c63-d755d7463ec9?prof=required)

for a list of updates of OCS 2007 R2 & Clients see this website:
--> http://technet.microsoft.com/en-us/office/ocs/ee695846.aspx

Greetz,
Tonino Bruno