here's the setup:
- Windows Server 2003 R2
- MSSQL Server 2005
- TSM BAC 5.5.2.0
- TDPSQL 5.5.2.0
- Two Windows servers are clustered
I created two scripts (SQLFULL.CMD and SQLINCR.CMD) and can run both manually. They work great.
When I try to run via a SQL agent or with the query "
xp_cmdshell 'G:\Micros~1\MSSQL.1\MSSQL\Backup\sqlfull.cmd';" it fails with the following: "
ACO5716W An error was encountered with Tivoli Storage Manager API initialization, rc = 106.
Examine the dsierror.log for more information or determine if the TSM API is installed properly."
I checked the dsierror.log file and it is empty.
I can run other xp_cmdshell commands just fine. for example "xp_cmdshell ;ping localhost' and I get the ping results.
I have removed, rebooted, and reinstalled both Tivoli clients.
Why can I run the script manually, but not from within SQL Server?
Thanks.
- Windows Server 2003 R2
- MSSQL Server 2005
- TSM BAC 5.5.2.0
- TDPSQL 5.5.2.0
- Two Windows servers are clustered
I created two scripts (SQLFULL.CMD and SQLINCR.CMD) and can run both manually. They work great.
When I try to run via a SQL agent or with the query "
xp_cmdshell 'G:\Micros~1\MSSQL.1\MSSQL\Backup\sqlfull.cmd';" it fails with the following: "
ACO5716W An error was encountered with Tivoli Storage Manager API initialization, rc = 106.
Examine the dsierror.log for more information or determine if the TSM API is installed properly."
I checked the dsierror.log file and it is empty.
I can run other xp_cmdshell commands just fine. for example "xp_cmdshell ;ping localhost' and I get the ping results.
I have removed, rebooted, and reinstalled both Tivoli clients.
Why can I run the script manually, but not from within SQL Server?
Thanks.