What is your server configuration? OS ? 32-bit or 64-bit?

use yourdbname

exec sp_change_users_login 'AUTO_FIX','yourloginname'

another way out of this is to delete schema & user from your database, recreate login and map itto your 3 database .

This seems to be a problem that remote access is not properly configured.

exec sp_configure 'remote access', 1

go

reconfigure

go

Specify what your job does...and what step 1 for

We had same problem couple of months ago with a PC running in the domain. To solve this problem, we manually created an DSN under administrator account, with TCP/IP connection...