Re: MS-SQL Agent connection error
2000-05-03 14:16:02
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
|
|
|