locked
Job failure for login access RRS feed

  • Question

  • Hi everyone,

    I got a weird job failure when administrate SQL Server 2005. the error message is like this:

    "Unable to determine if the owner (Domain\Login_Name) of job Job_Name has server access (reason: Could not obtain information about Windows NT group/user Domain\Login_Name'".

    I checked the owner of the job, and it is empty. How come I got a job owner error when there is no owner at all?

    I also tried using my own domain account which has sysadmin access as the job owner, but also got the same error. Could anyone give some advice? Thank you very much.

    regards,

    Oliver

    Tuesday, January 29, 2013 3:06 PM

Answers

  • the one case like if the job owner uses windows ID and that ID either dropper from the SQL server or removed from the domain that can cause the issue as well .

    eventhough if it exists might there is no proper permission to perform the operation  or if everything is fine the last resort like restarting of Agent will also work.

    ensure you should also have proper accesses in-order to change the job owner incase if you are going to change..!

    http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/47e7bc08-efa6-4a80-b8cd-1df92f10e7bc


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Oliver_Wang Friday, February 1, 2013 2:18 PM
    Tuesday, January 29, 2013 3:35 PM

All replies

  • the one case like if the job owner uses windows ID and that ID either dropper from the SQL server or removed from the domain that can cause the issue as well .

    eventhough if it exists might there is no proper permission to perform the operation  or if everything is fine the last resort like restarting of Agent will also work.

    ensure you should also have proper accesses in-order to change the job owner incase if you are going to change..!

    http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/47e7bc08-efa6-4a80-b8cd-1df92f10e7bc


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Oliver_Wang Friday, February 1, 2013 2:18 PM
    Tuesday, January 29, 2013 3:35 PM
  • Try to restart SQL Server Agent.
    Tuesday, January 29, 2013 3:40 PM
  • thank you all. Rama, what you said worked for me. Really appreciate~

    regards,

    Oliver

    Friday, February 1, 2013 2:18 PM