Hi all,

I keep trying to schedule a DTS job. I am testing it at the moment therefore doing it locally on my own hard drive.

However when I execute it, the job fails with the following error message:

"The job failed. Unable to determine if the owner (QWERTY\Pdavy) of job dts_Export_EM_tables3 has server access (reason: Could not obtain information about Windows NT group/user 'QWERTY\Pdavy'. [SQLSTATE 42000] (Error 8198))."

(In this case I have replaced the company name with QWERTY.)

Can someone please assist - I have also tried changing the owner to "sa" but it still fails. Why is it denying me access to my own disk?!

Thanks
Phil

Not an uncommon error, and nothing to do with DTS itself. Try -

834124 - How to troubleshoot a SQL Server 8198 error
(http://support.microsoft.com/?kbid=834124)

241643 - PRB: 8198 Error Message Returned from Job Owned by Windows NT
Authenticated User
(http://support.microsoft.com/?kbid=241643)

--
Darren Green
http://www.sqldts.com


"Phil Davy" <Phil Davy (AT) discussions (DOT) microsoft.com> wrote

information about Windows NT group/user 'QWERTY\Pdavy'. [SQLSTATE 42000]
(Error 8198))."