SQL Server 2000>Job step is failing with the following error

• Bagath

  SSCrazy

  Points: 2409

  More actions

  January 28, 2009 at 3:25 am

  #125955

  Hi all,

  SQL Server 2000 Job step is failing with the following error when executing it.

  Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.

  Could any one tell me the solution for the above prob? as well how to grant the permissions related to SQL Server agent job?

  Solution would be helpful to me.

  Thanks,

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 2, 2009 at 10:00 am

  #936543

  Can you provide some detail as what the job is doing?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question