|
Home > Archive > Microsoft SQL Server forum > May 2005 > SQL Job failing error 8198
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Job failing error 8198
|
|
| robin9876@hotmail.com 2005-05-23, 11:23 am |
| 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\UserAcco
unt) of job MyJobName has server access (reason:
Could not obtain information about Windows NT group/user '
DomainName\UserAccou
nt'. [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?
| |
| Simon Hayes 2005-05-24, 3:23 am |
| 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
| |
| robin9876@hotmail.com 2005-05-24, 7:23 am |
| 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?
| |
| Simon Hayes 2005-05-25, 7:23 am |
| See "Setting up Windows Services Accounts" in Books Online.
Simon
|
|
|
|
|