469,357 Members | 1,890 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,357 developers. It's quick & easy.

error 8198 when job is run

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

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
Apr 26 '06 #1
0 1890

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Wayno | last post: by
4 posts views Thread by robin9876 | last post: by
8 posts views Thread by Steve | last post: by
6 posts views Thread by Peter Frost | last post: by
16 posts views Thread by Steve Jorgensen | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.