Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiwikencox
Starting Member
11 Posts |
 Posted - 2005-10-13 : 21:07:06
|
| Hi all,I have a situation where i need to run a job using a DOMAIN\USERNAME owner but when i do this it fails with..."The job failed. Unable to determine if the owner...etc etc [SQLSTATE 42000] (Error 8198))"The job runs fine when the owner is set to 'sa' or the 'sql service account', but alas this is no good to me as the DTS package it runs call a batch file to copy a file from another machine, and sa & sql service accounts don't have access to this file. So DTS fails.Q: How can i get the job to work with DOMAIN\USERNAME owner??Q: Any suggestions on any workarounds??Cheers,Ken |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-13 : 22:15:06
|
| you already know what the job is supposed to do,next step is to determine the permissions needed to have that job runningand apply those permissions to the domain accountHTH--------------------keeping it simple... |
 |
|
|
|
|
|
Job fails & need to use domain\user acct to run