472,119 Members | 1,583 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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 1966

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.