JOb failed

• SQL_Novice23

  SSC Veteran

  Points: 201

  More actions

  July 10, 2014 at 4:37 am

  #309882

  I can run a stored proc in a query window no problem

  (stored proc queries a linked server via openquery).

  However when I schedule the proc in a Job it fails:

  authentication failed [SQL STATE] 42000 (error 7399)

  Sorry if this is a bit vague - any ideas as to how I resolve this?

  Thanks

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  July 10, 2014 at 6:02 am

  #1728345

  Does the SQL Agent service account has permission on the linked server?

  Look in the SQL Error log on the linked server and see the detaild errors regarding the failed login.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **