Error in Execution of a Job

#1

I am getting an error while executing a Job ..Has anyone
got an idea about the same..The error goes like this...

Executed as user: GECCEFDBY\##MSSQLServer.
SERVER_NAME.master.dbo.xp_fixeddrives [SQLSTATE 01000]
(Message 0) Access to the remote server is denied because
no login-mapping exists. [SQLSTATE 42000] (Error 7416).
The step failed.

Thanks..

#2

Do you have a linked server created for the server to which you want to
connect?

Ionel

"Harcharan Jassal" <harcharan.jassal (AT) seepz (DOT) tcs.co.in> wrote

Quote:

I am getting an error while executing a Job ..Has anyone
got an idea about the same..The error goes like this...

Executed as user: GECCEFDBY\##MSSQLServer.
SERVER_NAME.master.dbo.xp_fixeddrives [SQLSTATE 01000]
(Message 0) Access to the remote server is denied because
no login-mapping exists. [SQLSTATE 42000] (Error 7416).
The step failed.

Thanks..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error in Execution of a Job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Error in Execution of a Job - 07-02-2003 , 05:26 AM

Re: Error in Execution of a Job - 07-02-2003 , 04:04 PM