471,092 Members | 1,389 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

SQL Job failing error 8198

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?

Jul 23 '05 #1
4 9312
You don't give any information about your domain, but there are a
couple of KB articles which might be relevant:

http://support.microsoft.com/kb/834124
http://support.microsoft.com/kb/241643

If this doesn't help, I suggest you give some more information - what
MSSQL version, what OS version, what domain setup, what account is SQL
Agent running under, etc. By the way, running a job as sa has nothing
to do with accessing a network share - that depends on the SQL Agent
service account, so assuming that your service account is a domain one
with access to the share, you should probably try it anyway.

Simon

Jul 23 '05 #2
I have found the problem is the SQL Agent service account is a local
account. This is on a SQL Server 2000 SP3, Windows 2000 and Windows
Active Directory domain.
What permissions are required for a domain account to run as the SQL
Agent service account?

Jul 23 '05 #3
See "Setting up Windows Services Accounts" in Books Online.

Simon

Jul 23 '05 #4
hi robin,
When a SQL job has been created to run a local DTS package as per schedule 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)).

found ur post ..
how did u solve the problem
can u assist me as i am new into batch job maintanence activity
thank u
vignesh kannan
vigneshblue@gmail.com
Apr 26 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Simon Stewart | last post: by
7 posts views Thread by Chris Curvey | last post: by
reply views Thread by Sundeep Gawande | last post: by
8 posts views Thread by Chris Marsh | 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.