Mario,

I would recommend getting the latest version which is
Data Protection for SQL 5.5.3. You can find it here:
   
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v553/

This web page: 
   http://www-01.ibm.com/support/docview.wss?&uid=swg21403340
shows these prereqs:

    * Microsoft .NET Framework version 2.0 (or later)
    * Microsoft Core XML Services (MSXML) 6.0 (or later)
    * Microsoft SQL Server 2008 Native Client
    * Microsoft SQL Server 2008 Management Objects
    * Microsoft SQL Server System CLR Types 

Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 12/16/2009 
02:22:29 PM:

> [image removed] 
> 
> TDP SQL connection error
> 
> Mario Behring 
> 
> to:
> 
> ADSM-L
> 
> 12/16/2009 02:23 PM
> 
> Sent by:
> 
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> Please respond to "ADSM: Dist Stor Manager"
> 
> Hi list,
> 
> I´ve installed TDP for SQL 5.5.1 on a Windows 2008 Server with 
> Microsoft SQL Server 2008. I am getting the error below when trying 
> to connect the TDP for SQL agent using thetdpsqlc query SQL command:
> 
> 
> C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc query SQL
> 
> IBM Tivoli Storage Manager for Databases:
> Data Protection for Microsoft SQL Server
> Version 5, Release 5, Level 0.0
> (C) Copyright IBM Corporation 1997, 2007. All rights reserved.
> 
> Connecting to SQL Server, please wait...
> 
> ACO5422E Received the following from the MS SQL server:
> Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.
> 0.242.0, Culture=neutral, Public
> KeyToken=89845dcd8080cc91' or one of its dependencies. The system 
> cannot find the file specified.
> 
> 
> The tdpsqlc query tsm command connnects to the TSM Server without 
errors.
> 
> I´ve already searched the Microsoft website and instaleld the 
> Microsoft SQL Server 2008 Management Objects package.....but the 
> error remains.....
> 
> Mario
> 
> 
> 
>