Mario, Not sure if this is related, but if you are doing a scripted install, I have seen problems (specifically at tdp 5.5.2.0) where the scripted install appears to work correctly, but these type of errors pop up when you try to run a backup. the cause is 3 prereqs that the scripted install does not check or install. If you run the install/upgrade manually, the prereqs will be displayed and you can choose to have them installed for you. After that everything will work. BTW, my SQLServer engineer swears that these prereqs are in place prior to my install, but for whatever reason the tdp install doesn't recognize them until it "installs" them itself. -steve
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Sanju Chacko Sent: Wednesday, December 16, 2009 10:50 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP SQL connection error This error usually comes when there is an issue with pre-reqs install. Did you try repair on TDP? Thanks, Sanju -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Thursday, December 17, 2009 12:52 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP SQL connection error 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 ----------------------------------------------------- Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
