Linked Server Permissions from a Job

• dbadick

  SSC Journeyman

  Points: 82

  More actions

  April 2, 2003 at 5:17 pm

  #175343

  I have a linked server set up that points to an Oracle database. The security is setup with a local login and remote user & password defined. The connection will "not be made" flag is set so only this user can access this linked server. Windows authentication is being used here.

  When this user runs his sp from SQL Query Analyzer, all works fine. No errors...no problems.

  Now this user "domain\Lincoln" created a job to run this same sp and gets the following error in the sp step:

  Executed as user: domain\SQLService. Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.

  Now "domain\Lincoln" is the owner of the job. The log says that "domain\Lincoln" invoked this job. Why does SQLService user execute this step and not the owner of the job? How can I get "domain\Lincoln" to be the user executing this step?

  Thanks in advance.

  -Dick

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  April 3, 2003 at 7:44 am

  #453027

  Read KB http://support.microsoft.com/default.aspx?scid=kb;en-us;811031