We have an NT4.0 SP5 system with SQL 6.5. Recently upgraded from TSM client
3.1.0.6 and TDP MSSQL 1.1.1 to TSM 4.1.0.0 and TDP 1.1.1.01.
After we did, the SQL databases weren't being backed up. We use the
sqlfull.cmd for backups. When I checked logs I found this in sqlfull.log.
―--------------------------------------------------------------
03/01/2001 21:01:45,COMMAND LINE : C:\Progra~1\Tivoli\TSM\Mssql\sqldsmc
/sqluser:sa /sqlpwd:pwd /backupfull:*
/adsmoptfile:C:\Progra~1\Tivoli\TSM\Mssql\dsm.opt
/logfile:C:\Progra~1\Tivoli\TSM\Mssql\sqlfull.log
03/01/2001 21:01:45,Logging on to the TSM server...
03/01/2001 21:01:51,Logging on to the SQL server...
03/01/2001 21:01:51,ACO4210E -- Failed to connect to SQL server.
―-----------------------------------------------------------------------------
I can use the GUI and it connects to SQL server and backs up databases I can
use the GUI and it connects to SQL server and backs up databases o.k. I can
run the sqlfull.cmd on an NT window and it runs o.k. there. When this
sqlfull.cmd is run from TSM Server, it does run because the ADSM autodelete,
which is the last line in cmd does run successfully.
(We did have problems deleting the "old" *SM stuff from the NT machine before
installing new versions. The uninstall didn't work at all and our NT Admin,
who is really good, had a difficult time deleting files and Registry entries
for old stuff. There had apparently been some ODBC installed sometime in the
past and that may have been part of problem.)
I checked Tivoli Web site and can't find any relevant info. Why can't it
connect to SQL when run as CMD from TSM Server?
Thanks for ideas,
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5525
david.longo AT health-first DOT org
"MMS <health-first.org>" made the following
annotations on 03/05/01 10:34:15
------------------------------------------------------------------------------
This message is for the named person's use only. It may contain confidential,
proprietary, or legally privileged information. No confidentiality or
privilege is waived or lost by any mistransmission. If you receive this
message in error, please immediately delete it and all copies of it from your
system, destroy any hard copies of it, and notify the sender. You must not,
directly or indirectly, use, disclose, distribute, print, or copy any part of
this message if you are not the intended recipient. Health First reserves the
right to monitor all e-mail communications through its networks. Any views or
opinions expressed in this message are solely those of the individual sender,
except (1) where the message states such views or opinions are on behalf of a
particular entity; and (2) the sender is authorized by the entity to give such
views or opinions.
This message is for the named person's use only. It may contain confidential,
proprietary, or legally privileged information. No confidentiality or
privilege is waived or lost by any mistransmission. If you receive this
message in error, please immediately delete it and all copies of it from your
system, destroy any hard copies of it, and notify the sender. You must not,
directly or indirectly, use, disclose, distribute, print, or copy any part of
this message if you are not the intended recipient. Health First reserves the
right to monitor all e-mail communications through its networks. Any views or
opinions expressed in this message are solely those of the individual sender,
except (1) where the message states such views or opinions are on behalf of a
particular entity; and (2) the sender is authorized by the entity to give such
views or opinions.
===========================================================================
|