How to install OCS2009-DBUpgrade
Posted by Ståle Hansen on 08/11/2009
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
- Microsoft SQL Server 2005 Management Objects Collection
- 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
Installing OCS 2007 R2 Prerequisites on Windows Server 2008 R2 « msunified.net said
[...] Guide for updating the pool DB can be found here: http://msunified.net/2009/11/08/how-to-install-ocs2009-dbupgrade/ [...]
Andy said
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.
July Cumulative Updates for Communications Server 2007 R2 « UC by UC said
[...] 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. [...]
How to install OCS2009-DBUpgrade « msunified.net « JC’s Blog-O-Gibberish said
[...] http://msunified.net/2009/11/08/how-to-install-ocs2009-dbupgrade/ [...]
TechnoMusic said
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
Ståle Hansen said
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.
How to UNinstall OCS2009-DBUpgrade « Заметки ИТ инженера said
[...] заметка. Хорошая статья How to install OCS2009-DBUpgrade А вот меня очень заинтересовало как сделать UNinstall, ну [...]