Scheduling DTS Packages - The Job failed. Unable to determine if the owner....

Hi There,

I have create a DTS package and have tested it by running it manually from the enterprise manager console and it works ok.

The problem I am having is that when I schedule this job to run it failes reporting the following error message.

The job failed.  Unable to determine if the owner (Domain\<username>) of job Import <JobName> has server access (reason: Could not obtain information about Windows NT group/user 'Domain\<username'. [SQLSTATE 42000] (Error 8198)).

I have tried changing the owner of the job to various other users including the systeme administrator but still no luck.

Any ideas ???

Regards

David
dwadleyAsked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
If you create the job to run as the domain admin account and you are NOT the domain admin, the job will inherit your rights and not the rights of the domain admin....

Brett
0
 
Eugene ZCommented:
Check 'SQLServerAgent' service logon account,
see also:
http://www.cryer.co.uk/brian/sqlserver/mscagnt_jbflduosa.htm
0
 
dwadleyAuthor Commented:
The service logon account is the domain administrator account.
The owner of the job is the same domain administrator account.

I still get the same error message

Where do you set the permissions to allow the administrator to run this job ?

0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
sebastianlinkCommented:
Make sure data sources (DSN) you use are system DSN and not user DSNs.
0
 
arbertCommented:
DSNs don't affect the owner of the job....
0
 
Eugene ZCommented:
Then check  UIDs\PWDs inside your DTS package, if you have any... .
0
 
dwadleyAuthor Commented:
So Brett,

Are you saying I should log off and then back on again as the domain admin and schedule the job ??

David
0
 
dwadleyAuthor Commented:
So Brett,

Are you saying I should log off and then back on again as the domain admin and schedule the job ??

David
0
 
dwadleyAuthor Commented:
So Brett,

Are you saying I should log off and then back on again as the domain admin and schedule the job ??

David
0
 
arbertCommented:
If that's the account you're actually trying to run the package with.

Check these out too:

http://support.microsoft.com/default.aspx?scid=kb;en-us;233161

http://support.microsoft.com/default.aspx?scid=kb;en-us;269074


The second article is a good explanation of who owns a package and who can schedule it.

Brett
0
 
dwadleyAuthor Commented:
OK I got it going - thanks for your help

I changed the owner of the scheduled job to the SA account and all worked

Enterprise Manager -> Management -> Job Name - > Properties -> Changed Owner from Administrator of domain to SA

Not sure who to award the points to though - I guess EugeneZ as he was the first to reply ?


0
All Courses

From novice to tech pro — start learning today.