Groups | Blog | Home
all groups > sql server dts > june 2004 >

sql server dts : Error executing a job with SQL Server Agent



Michael Vardinghus
6/28/2004 9:38:35 AM
Does anybody know what to do with this one:

Unable to determine if the owner (xxx) of job xxx has server access reason.
Could not obtain information about Windows NT group/user xxx. SQLSTATE
42000. Error 8198.

The owner of the job is set to the specific user - the user is part of a
windows group on the domain which has Administrator rights.

Has it something to do with the Service Statup account of SQL Server Agent ?
However if i manually start try to start the job i get the same error - if I
change the package owner to SA and then manually start the job it works.

I'm running on an SQL Server 2000 but in the domain there is also SQL Server
7 - but it sounds like a problem related to my machine / user rights.

\Michael Vardinghus

Narayana Vyas Kondreddi
6/28/2004 10:58:22 AM
Have you checked the KB?

http://support.microsoft.com/default.aspx?scid=kb;en-us;241643
http://support.microsoft.com/default.aspx?scid=kb;en-us;834124
See if the above help!
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


[quoted text, click to view]
Does anybody know what to do with this one:

Unable to determine if the owner (xxx) of job xxx has server access reason.
Could not obtain information about Windows NT group/user xxx. SQLSTATE
42000. Error 8198.

The owner of the job is set to the specific user - the user is part of a
windows group on the domain which has Administrator rights.

Has it something to do with the Service Statup account of SQL Server Agent ?
However if i manually start try to start the job i get the same error - if I
change the package owner to SA and then manually start the job it works.

I'm running on an SQL Server 2000 but in the domain there is also SQL Server
7 - but it sounds like a problem related to my machine / user rights.

\Michael Vardinghus


Michael Vardinghus
6/28/2004 7:46:07 PM
Thanks a lot -- preciously...

[quoted text, click to view]

AddThis Social Bookmark Button