SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

HP Data Protector - SQL Server 2008 Supported, but Compatibility Pack 2005 Required


Recently, we found out that HP Data Protector had an update, and I took for granted that this update would make the product more compatible with SQL Server 2008 - but it still doesn't support SQL Server 2008 without installing the Backwards Compatibility Pack from SQL Server 2005
Not entirely such a pain, but just be aware, HPDP fans, that this warning message 'SQL DMO Component is not available which will cause MS SQL Integration to fail' really means to say you should download the
SQL Server 2005 Backwards Compatibility Pack (SQLServer2005_BC_x.msi). If you read the fine print of their Support Manual, you`ll notice on page twelve, point seven, that the SQL DMO download is required.

SQL-DMO warning during Data Protector Install

If you haven't installed the Backwards Compatibilty Pack first, then when using HP Data Protector with SQL Server 2008, you will see this error (HR 0x80040154] Class not registered): 

Class not registered Error

Or notice this error in your Debug.txt (set this in properties) in your Sysroot\Program Files\Omniback folder:

25/03/2010 11:27:48 AM  OB2BAR_Main.796.2948 ["integ/sql_7/sql7_dmo.cpp /main/hsl_dp61/hsl_hpit2_2/1":288] A.06.11 b243
[SQL7_Login] Failed creating object instance. Err code: -2147221164, REGDB_E_CLASSNOTREG
Function trace (currentLevel=3):
 Level  3: SQL7_Login()
 Level  2: SQL7_CheckConfig()
 Level  1: SQL7_Config()
 Level  0: main()

When Installing the SQL Server 2005 Backwards compatibility Setup, you only need the SQL DMO object components for HP Data Protector to work correctly with SQL Server 2008.


Posted by peterku on 13 January 2011

Hi thanks for this very useful information. Does the SQL Server 2005 Backward compatibility pack need to be installed on the SQL server or the DP cell manager?

Posted by Hugo Shebbeare on 20 March 2012

Hello Peter, sorry for the terribly late reply - The Cell Manager side for sure, and the SQL Server side if you want to run HPDP cell manager locally.

Thank you for the comment, just wanted to save others a HUGE headache, as I had gone through before 2008 worked with HPDP.

Leave a Comment

Please register or log in to leave a comment.