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@VM.MARIST.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@VM.MARIST.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 > > > >
