ADSM-L

Re: MS-SQL Agent connection error

2000-05-03 14:16:02
Subject: Re: MS-SQL Agent connection error
From: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Wed, 3 May 2000 14:16:02 -0400
Hi Del:

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com 
>>> hoobler AT US.IBM DOT COM 05/03/00 01:21PM >>

>1. What level of the SQL Application Client are you running?
1). 1.1.2 (update added to allow restores to DB copies and the autodelete.)

>2. What is the EXACT command-line syntax that you are using?
2). The basic sample, site tailored and autodelete added. The autodelete is 
working.................
@ECHO OFF
set sql_dir=D:\WIN32APP\IBM\ADSM\BACLIENT\agentsql
D:
cd %sql_dir%
date < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log
%sql_dir%\sqldsmc /backupfull:* /adsmoptfile:%sql_dir%\dsm.opt 
/logfile:%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log
%sql_dir%\sqldsmc /adsmautodelete:* /adsmoptfile:%sql_dir%\dsm.opt 
/logfile:%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log /ifolder:10

>3. Did you try specifying /SQLUSER: and /SQLPWD: or /SQLSECURE options?
3). Would I need to? The password is saved and the the GUI backs up the db with 
no problem. Also, the method above is equivalent on all clients ( four working).

>4. Are your running on a cluster server? (MSCS)
4. No

>5. What happens when you use the "/SQLSERVER:your-server-name" option?
5. Haven't tried that, but again, we do have four servers working.

Larry Clark
NYS Thruway Authority


----------------------------------------------------
Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US> on 05/03/2000 09:48:00 
AM
Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US> on 05/03/2000 09:48:00 
AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU 
cc:
Subject:  MS-SQL Agent connection error




Hi:

We currently have 5 MS-SQL Agents and 4 run with no problem.

The one with the problem ( not doing a scheduled backup ) has this error in
the dsmsched.log: AC04210E

A backup using the GUI does run with no problems and has the password saved
so I am assuming it is not a userid / password problem to the database.

This particular database is on a proxy server.

Any suggestions on determining the cause of the connection error?

Larry Clark
NYS Thruway Authority
<Prev in Thread] Current Thread [Next in Thread>