scheduled job (a sp) not running

• JDNospam

  Grasshopper

  Points: 11

  More actions

  January 31, 2006 at 8:13 pm

  #112367

  I've scheduled a job that executes a sp that includes a reference to a linked server (connected over a LAN).

   

  The sp runs fine in QA.

  However, the scheduled job fails with the following error message: "SQL Server does not exist or access denied. [SQLSTATE 42000](Error 17)."

  Any ideas?

• Michael Lee-169622

  SSCommitted

  Points: 1721

  More actions

  February 2, 2006 at 7:50 am

  #618395

  I suspect you have a major permissions problem. When you run the sp in QA, you are running it using your permisisons, on your local workstation. When you run the job, it is using the login of whatever the SQL Server Agent is using on the server, also, the sp is then running on the server. I am sure whatever your login is for the SQL Server Agent does not have the proper permissions on the linked server.

  ---

  Shalom!,

  Michael Lee