locked
Agent jobs failed RRS feed

  • Question

  • SQL server 2008 R2 agent jobs starting failing with following error:
    "The job failed.  Unable to determine if the owner (domain\login) of job MaintenancePlan - ABC.Full backup has server access (reason: Could not obtain information about Windows NT group/user 'domain\login', error code 0x5. [SQLSTATE 42000] (Error 15404))".

    Any help.
    Thanks

    Thursday, June 6, 2013 8:23 PM

Answers

  • You dont need to run your job with SA its always not recommended for security purposes its good to run SQL with service account..you can check with your AD team for ur prev account ...see whether its disabled or some rights are removed due to some policy Push..you must be aware about rights to this acount ..restore the rights and u are good to go..

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621MVP Friday, June 7, 2013 8:15 AM
    • Marked as answer by Fanny Liu Friday, June 14, 2013 6:39 AM
    Friday, June 7, 2013 8:13 AM
  • This happens when the Job owner AD account is disabled or deleted.  You need to change the owner to a valid user.

    • Marked as answer by Fanny Liu Friday, June 14, 2013 6:39 AM
    Thursday, June 6, 2013 8:38 PM

All replies

  • This happens when the Job owner AD account is disabled or deleted.  You need to change the owner to a valid user.

    • Marked as answer by Fanny Liu Friday, June 14, 2013 6:39 AM
    Thursday, June 6, 2013 8:38 PM
  • It happens when AD domain controller is not available or too busy to authenticate user.

    Please set up job owner under SQL user.


    Thursday, June 6, 2013 9:13 PM
  • H bro

    Just change  owner to sa  and all will be good.

    Or

    Refer this solution


    Thanks Saurabh Sinha

    http://saurabhsinhainblogs.blogspot.in/

    Please click the Mark as answer button and vote as helpful if this reply solves your problem


    Friday, June 7, 2013 2:49 AM
  • You dont need to run your job with SA its always not recommended for security purposes its good to run SQL with service account..you can check with your AD team for ur prev account ...see whether its disabled or some rights are removed due to some policy Push..you must be aware about rights to this acount ..restore the rights and u are good to go..

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621MVP Friday, June 7, 2013 8:15 AM
    • Marked as answer by Fanny Liu Friday, June 14, 2013 6:39 AM
    Friday, June 7, 2013 8:13 AM