How to install OCS2009-DBUpgrade

08/11/200909/01/2011Ståle Hansen 8 Comments

[tweetmeme source=”stalehansen” only_single=false]On several OCS 2007 Enterprise installations this patch was not that easy to install when you are using SQL 2008 backend database. Here’s what I had to do to install this patch

To apply the hotifx, you must have the following software installed.

OCS administration tools
MS SQL Native Client
- X64 Package (sqlncli.msi) – 7963 KB
If you decide to install SQL 2008 Client Tools, SQL 2005 Service Pack 2 (SP2) Backward Compatibility must also be installed.
To install the SQL 2005 Service Pack 2 (SP2) Backward Compatibility you need to download and install
- Microsoft SQL Server 2005 Management Objects Collection
  - X64 Package (SQLServer2005_XMO_x64.msi) – 14675 KB
- Microsoft SQL Server 2005 Backward Compatibility Components
  - X64 Package (SQLServer2005_BC.msi) – 18569 KB
Finally run the patch with the following command when on a OCS Enterprise deployment
- OCS2009-DBUpgrade.msi POOLNAME=poolname

If the installation failes check Scott Oseychik’s post about SQL won’t allow update here: http://blogs.msdn.com/scottos/archive/2009/08/21/installation-of-ocs-2007-r2-hotfix-package-969834-may-fail-if-sql-settings-have-been-changed.aspx

View the full technical article here: http://support.microsoft.com/kb/969834

8 thoughts on “How to install OCS2009-DBUpgrade”

Installing OCS 2007 R2 Prerequisites on Windows Server 2008 R2 « msunified.net says:

09/04/2010 at 00:29

[…] Guide for updating the pool DB can be found here: https://msunified.net/2009/11/08/how-to-install-ocs2009-dbupgrade/ […]

Reply
Andy says:

16/04/2010 at 01:30

Thanks so much for this. I don’t know why it is above Microsoft to make this stuff easier. Those were the backward compatible things I needed.

Reply
July Cumulative Updates for Communications Server 2007 R2 « UC by UC says:

27/07/2010 at 00:12

[…] A few people have mentioned issues with the latest update but this appears to be because the OCS2009 DBUpgrade hasn’t been applied. This needs to be applied separately for a good description of how to apply this patch there are a number of blog entries such as the one on msunified. […]

Reply
How to install OCS2009-DBUpgrade « msunified.net « JC’s Blog-O-Gibberish says:

29/08/2010 at 16:29

[…] https://msunified.net/2009/11/08/how-to-install-ocs2009-dbupgrade/ […]

Reply
TechnoMusic says:

19/07/2011 at 16:51

Should the db update be done before or after the server updates? Also did you run the db update on FE OR BE?
Thanks a million
P

Reply
- Ståle Hansen says:
  
  19/07/2011 at 17:33
  
  I recommend doing the DB update after the server updates, but before you reboot the FE server. Usually I run this update on the FE, as long as firewall ports and the SQL prerequisites are available I think that is the simplest way to go about it.
  
  Reply
  - Jarrod says:
    
    07/06/2013 at 15:56
    
    Thank you so much for this information. We’re patching our two front end servers before upgrading to Lync. I did have one question. We have two front ends but no load balancer (we switch the DNS record if we need to “cut” over). My plan is to patch the passive server and the DB, then cut the clients over with the DNS change, and patch what will now be the passive FE.
    
    If I patch the passive server and the DB, will the clients disconnect that are using the active FE server?
    
    Reply
How to UNinstall OCS2009-DBUpgrade « Заметки ИТ инженера says:

17/12/2011 at 22:57

[…] заметка. Хорошая статья How to install OCS2009-DBUpgrade А вот меня очень заинтересовало как сделать UNinstall, ну […]

Reply