Del,

Thanks!  It seems that running the command file from a prompt with
"/sqlsecure" worked fine, but when the command file is run from a
schedule, I had to specify the user and password.

Thanks again.

Barry Hill
Network Specialist
Medical Center Hospital

> -----Original Message-----
> From: Del Hoobler [SMTP:hoobler AT US.IBM DOT COM]
> Sent: Tuesday, July 07, 1998 7:51 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: ADSMConnect Agent for MS-SQL Error Messages
>
> Barry,
>
> Make sure the ADSM Scheduler Service is running as a user that
> has the correct permissions to access the SQL Server.
> You can check this by looking at the "Log On As:" parameter
> in the NT "Services" program under "Startup".
> The default of "System Account" may not work.
> ...or try using the "/SQLUSER:username" and "/SQLPWD:password" options
> on the "SQLDSMC" command.
>
> Del Hoobler
> ADSM Agent Development
>
> >> Where are the error messages for the MS-SQL Connect Agent?
> >>
> >> Or, can someone help me with this message?
> >>
> >> ANSQL119E -- Failed to connect to SQL server.
> >>
> >> This comes from a .CMD job that runs fine if started from the
> command
> >> line, but gets this error when started by the scheduler.
> >>
> >> Thanks in advance,
> >>
> >> Barry Hill
> >> Network Specialist
> >> Medical Center Hospital