Home Forums SQL Server 2008 SQL Server Newbies Is it possible to limit the privileges for SQL Server agent? RE: Is it possible to limit the privileges for SQL Server agent?

  • e4d4 (7/12/2015)


    No, account that use SQL Agent must be a member of sysadmin role. https://msdn.microsoft.com/en-us/library/ms191543.aspx

    Not sure why this recommendation is being made by MS.

    I have never granted sysadmin to the SQL agent account. It's part of the public group and that's about it.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/