When a SQL job has been created to run a local DTS package 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 have seen other articles about changing the owner to SA, this would
not work as a domain account is required to connect to a network share.
How can I get the SQL Job to run as a domain account?