Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Question Unanswered: Cannot Start SQL Server Agent

    Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"

    I log in to the SQL Server as 'sa'. What could be the possible problem?

  2. #2
    Join Date
    Mar 2003
    Location
    Bucharest, Romania
    Posts
    80

    Re: Cannot Start SQL Server Agent

    Originally posted by AlveenX
    Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"

    I log in to the SQL Server as 'sa'. What could be the possible problem?

    What user is set to startup the SQLAgent service? This user must be added in SQLServer logins and give system administrator rights over the SQLServer.


    ionut
    ionut
    Who cares about Romanian football ???

  3. #3
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163
    The easy way (i think), on Services, try to put the service starting with the "local system account"

  4. #4
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    SQL Server uses a windows account to start the sql server agent service. This user should have preferably administrator rights on the machine where the sql server resides. This user can be a local user ( in that case "local system account" is best, as pal19 already mentioned) or, if the sql server has to communicate with other (sql) servers, a domain user account.
    You can change the user account that is used in the enterprise manager. Go to management --> sql server agent --> right click and select properties --> general tab. You can also go to the services tab in the Windows administrative tools and change the properties of the sql server agent service there.
    Johan

  5. #5
    Join Date
    Oct 2003
    Posts
    2

    Thumbs up Thanks

    Thanks Jora, Pal19 and Ionut Calin. SQL Server Agent has eventually started. Thanks so much for your help.

    AlveenX

Posting Permissions

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