Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    39

    Unanswered: Help---SQL Agent Security

    We have sensitive data that requires the builtin\administrators group be removed so domain admins are unable to see data. When we do this, SQL can continue to run under the local system account, but the SQL Agent cannot.

    Does anyone else have a solution that will lockout NT admins (both local and domain) and allow both SQL and the SQL AGENT to run properly?

    TIA

    Ryan Hunt

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you give the new domain account sysadmin rights?

    And configure it to start with that account?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2003
    Posts
    39
    Thanks for the response. I ended up just creating a local admin account for the agent with specific SA rights to the server. Then, had the only department allowed to have access to the data change the password. This seems like the best choice...

    Thanks

Posting Permissions

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