ADSM-L

Re: MS-SQL Agent connection error

2000-05-05 11:30:50
Subject: Re: MS-SQL Agent connection error
From: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Fri, 5 May 2000 11:30:50 -0400
Del:
I did try adding the /SQLPWD password parm to the command line and firing it 
off in a DOS prompt and it worked.

Would you know why it might be required on this one server and not the others. 
I do have the password set via the GUI interface with the save password 
selected, and the GUI does do the backup without a prompt for a password.

I thought the password was encrypted and stored and accessible when the command 
line or script was executed.

Larry Clark
NYS Thruway Authority

>>> hoobler AT US.IBM DOT COM 05/03/00 01:21PM >>>
Larry,

1. What level of the SQL Application Client are you running?

2. What is the EXACT command-line syntax that you are using?

3. Did you try specifying /SQLUSER: and /SQLPWD: or /SQLSECURE options?

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

5. What happens when you use the "/SQLSERVER:your-server-name" option?

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com 


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>