Is the login need to be part of Local/Domain Admin for SQL Server Agent?

• Harinath Pottam

  SSC Enthusiast

  Points: 199

  More actions

  January 21, 2007 at 10:36 pm

  #171864

  I need to limit database access to a login who is part of Domain/Local Admin group. One suggestion, was to DENY permission to SQL's BUILTIN/Administrators group. If I do that the SQL Agent would not start. We rum SQL Mail as well.

  Is there a way out?

  Thanks in advance.

  Hari

• sivaprasad

  SSCertifiable

  Points: 6183

  More actions

  January 21, 2007 at 10:49 pm

  #684600

  1.Deny permission to 'Builtin\Administrator' group

  2.Add the SQL Agent account login and grant the 'sysadmin' privileges

  Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

• Harinath Pottam

  SSC Enthusiast

  Points: 199

  More actions

  January 24, 2007 at 11:01 pm

  #685421

  I tried the method and SQLAGENT did not start. However, when I deleted the group, it worked.

  Thanks though.

  Harinath