Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    2

    Unanswered: SQLServeragent security context does not have....

    Hi,

    We have a sqlserver 7 on windows nt 4.
    We'd just change a startup account for sqlserver agent to a
    not domain admin for security reason. The startup account for sqlserver service is
    still domain admin. We are now getting the following error every 5 second
    in our application event log.

    "SQLServeragent security context does not have server-autorestart privileges"

    Is there a way to get rid of this error without putting a domain admin as
    a startup account for sqlserver agent?

    Ted

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    You should make the account used by SQL Sever Agent a local administrator (add it to the local machine's Admin group).
    -bpd

Posting Permissions

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