I am guessing that you are running with SQL Server 2000?


There are some prerequisites when using Data Protection for SQL 5.5 with
SQL Server 2000.
The book lists these requirements here:

http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmfd.doc/dpsql52.htm


In a nusthell:

If Data Protection for SQL is to be used with SQL Server 2000, the
following prerequisite software is required:

1) Microsoft .NET Framework Version 2.0 or later
http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en


2) Microsoft Core XML Services (MSXML) 6.0 or later
3) Microsoft SQL Server Native Client
4) Microsoft SQL Server 2005 Management Objects Collection

Items 2 - 4, can be obtained here:
http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en



Thanks,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/20/2008
07:45:05 PM:

> I just upgraded a 5.2 version of tdpsql to 5.5 and am getting the
> following message in the tdpsql.log. Has anyone seen this when
> upgrading?
>
>
>
> 02/20/2008 16:40:01
> ========================================================================
> =
>
> 02/20/2008 16:40:01 Request                       : QUERY SQL
>
> 02/20/2008 16:40:01
> ------------------------------------------------------------------------
> -
>
> 02/20/2008 16:40:01 ACO5422E Received the following from the MS SQL
> server:
>
> 02/20/2008 16:40:01 Could not load file or assembly
> 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral,
> PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system
> cannot find the file specified.