Configuring an sql server agent account

  • I get this error while trying to configure an account to be used by sql server agent and sqlserver.

    "Sql server enterprise manager does not have sufficient permission to verify the sql server agent start up account."

    The account to be used is a service in the domain and has admin rights.

    Mike

  • Sort of sounds like there is an issue with the SQL server account not the sql agent account. Do any other accounts work against the SQL server ? Perhaps see if there are any differences between them and the one you are trying to use ?


    ------------------------------
    Life is far too important to be taken seriously

  • I get same error message when I change the window account from Administrator to user.

    All the articles I read it recommend to use domain limit user account for sqlsever and sqlserver agent. So I set a window account as user (the server is stand alone) and I add the same user in the sql with the same password with sysadmin permission.By doing this I get the error above until I change the window user account to Administrator permission. I have been trying for a while but no luck

    Any help will be apprciated

    sincerely,

    Note: the sql server in mixed mode and I have to have it in this option.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply