locked
Access denied starting SQL agent RRS feed

  • Question

  • Hi All,

    unable to start sql agent in sql server 2008R2 sp3 using Local account or domain user with sysadmin access.

    The SQL Server Agent (ISDB01) service failed to start due to the following error:

    Access is denied.

    Neeed help on the same.

    Friday, July 3, 2015 11:26 AM

Answers

  • Refer this link Click Here
    Friday, July 3, 2015 11:28 AM
  • Hello - SQL Server Agent Service Accounts must have sysadmin permission

    No, Agent does not need to be Administrator in Windows. But it may be correct that it needs to be sysadmin in SQL Server.

    In any case, such permission problem should be possible to sort out with SQL Server Configuration Manager. Set the service account from this application, and it will grant the permissions required. Do not use the Services applet in Computer Management, which assumes all permissions have already been granted.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Friday, July 3, 2015 9:32 PM

All replies

  • Refer this link Click Here
    Friday, July 3, 2015 11:28 AM
  • Hello - SQL Server Agent Service Accounts must have sysadmin permission on the OS and SQL Server to start this service.

    You need to make sure that the above is granted, or you can try to change the service account to use "Local System" account and test this operation again

    Please note that: The built-in local system a member of the Administrators group on the local computer, and is therefore a member of the sysadmin role within SQL Server automatically BUT this is provided for backward compatibility we therefore advise (For enhanced security) you to use a Windows domain account.

    More Information here:

    http://support.microsoft.com/kb/283811/en-us
    http://msdn2.microsoft.com/en-us/library/ms143691.aspx

    Hope this helps !




    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    Friday, July 3, 2015 11:39 AM
  • Hello,

    Make sure the service account has modify permissions at the operating system level over the folder containing the SQL Server databases.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, July 3, 2015 2:56 PM
  • Hello - SQL Server Agent Service Accounts must have sysadmin permission

    No, Agent does not need to be Administrator in Windows. But it may be correct that it needs to be sysadmin in SQL Server.

    In any case, such permission problem should be possible to sort out with SQL Server Configuration Manager. Set the service account from this application, and it will grant the permissions required. Do not use the Services applet in Computer Management, which assumes all permissions have already been granted.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Friday, July 3, 2015 9:32 PM