tags:

views:

18

answers:

0

I have a job that I'd like to run in SQLServer 2008 that needs to get some data from our SQLServer 2000 db so I'm using OPENQUERY to get that data. When I execute the job I get the following error:

Executed as user: SEDONAGROUP\sqlage. Login failed for user 'SEDONAGROUP\sqlage'. [SQLSTATE 28000] (Error 18456). The step failed.

The Stored Procedure that the job calls runs fine if run as an SP rather then a job. I think the issue may be that there is no user called sqlage on the target machine? I just tried adding a sqlage as sysadmin on the target machine that that didn't work.

Any sugestions?