Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2010
    Posts
    6

    Smile Unanswered: SQL agent starts under local account not service account

    I have an ACTIVE/ACTIVE cluster the sql agent on one node will only start under Local account not under service account but the agent on other node starts under service account I already assigned sysadm privilege to builtin/administartor account. SQl version is 9.0.3186 with SP2. Any help will be appreciated

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Are there any error messages in the SQLAgent errorlog, or the system or application event logs? I expect the domain account does not have the same rights on each box.

  3. #3
    Join Date
    Feb 2010
    Posts
    6
    Thanks for the reply not really any error messages I was under an impression that domain account is for all servers had to check with NT admin if there are any differnces in permission

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Domain accounts can have vastly different permissions on different boxes.

  5. #5
    Join Date
    Feb 2010
    Posts
    6
    Thanks I will ask my NT admin to look into the permissions, really appreciate your tima and help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •