Tuesday, June 15, 2010

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). 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.

No comments:

Post a Comment