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
|
|
|