3
When a SQL job has been scheduled to run a DTS package automatically it fails with the following error message.
The job failed. Unable to determine if the owner
(DomainName\UserAccount) of job MyJobName has server access (reason:
Could not obtain information about Windows NT group/user '
DomainName\UserAccount'. [SQLSTATE 42000] (Error 8198)).
The package runs if executed from the DTS Local Packages in Enterprise
Manager.
I changed the owner to SA in the ini file of the batch job but it didn't help anyway.
How can I get the SQL Job to run as per schedule
