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
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).