Installation of OCS 2007 R2 Hotfix Package 969834 may fail if SQL settings have been changed

  • Article

Summary:

Installation of the OCS 2007 R2 “Backend” hotfix package (https://support.microsoft.com/kb/969834) may fail, and unfortunately, the error message presented to the Administrator isn’t entirely clear as to what the root cause is.

 

 

More Information:

If you find that installation of OCS2009-DBUpgrade.msi is failing against your backend SQL RTC databases, locate and open the resulting QFE_DBSetup.log file. The following output is generated in the QFE_DBSetup.log, and note the highlighted entry below:

 

/PoolName: specified FQDN. Assuming /PoolName:R2POOLNAME.contoso.com

Attempting to discover BackEnd SQL instance from AD.

LDAP Query (ConfigurationNamingContext): LDAP://CN=Configuration,DC=contoso,DC=com;((&(objectClass=msRTCSIP-Pool)(msRTCSIP-PoolType:1.2.840.113556.1.4.803:=2)(msRTCSIP-PoolDisplayName=R2POOLNAME.contoso.com)));distinguishedName,msRTCSIP-BackendServer;subTree

Backend Server Instance List: R2BESQL

Backend Server Instance for Pool 'R2POOLNAME.contoso.com' is 'R2BESQL'

Discovered SqlServer R2BESQL

Updating EE server database stored procedures. This will take a while ...

cscript dbsetup.wsf /Verbose /Role:ee /SqlServer:R2BESQL

Microsoft (R) Windows Script Host Version 5.6

Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

Installed SQL Server 2005 Backward Compatibility version is 8.05.2004

Connecting to SQL Server on R2BESQL

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.

[Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc update to system catalogs is not supported.

Workaround:

1. In SQL Server Management Studio, run the following SQL statement:

sp_configure 'allow updates', '0'

RECONFIGURE WITH OVERRIDE

2. Re-run OCS2009-DBUpgrade.msi

Credit:

Many thanks to Santhosh K for finding this needle in the haystack while I was busy waking up half of the RTC Dev Team. :-)