SQL Server Performance

DTS package scheduling error

Discussion in 'SQL Server DTS-Related Questions' started by hazee, Jul 13, 2008.

  1. hazee New Member

    I am using SQL server 2000 and I have got a DTS package which is transforming data from a CSV (Excel) file to SQL server file. This package works fine but If i try to schedule it, generates an error ""The job failed, Unable to determine if the owner ServerNameUserName of job ABC has server access.(reason could not obtain information about Windows NT group/user [SQLSTATE 42000] [ERROR 8198])"

    I have tried runningthe schedule with different user accounts but the result is still same.Any idea what is this happening?


    Thanks in advance,
    hazee
  2. martins New Member

    Check the account that SQL Server Agent services run as, and make sure this account has appropriate permissions. If you still get the same error, I would suggest you check whether the owner of the job has appropriate permissions as well as the account that the DTS package will run as (check the properties in the DTS package).

Share This Page