ADSM-L

Re: ADSMConnect Agent for MS-SQL Error Messages

1998-07-07 08:50:31
Subject: Re: ADSMConnect Agent for MS-SQL Error Messages
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Tue, 7 Jul 1998 08:50:31 -0400
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
<Prev in Thread] Current Thread [Next in Thread>