Results 1 to 3 of 3

Thread: sql server agent not starting

  1. 06-15-2005, 11:36 AM #1
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188

    sql server agent not starting

    Hi have you guys seen this error when trying to start the sql agent?

    SQLServerAgent could not be started (reason: sqlserveragent must be able to connect to sqlserver as sysadmin, but '(unkown)' is not a member of the sysadmin rol.

    What is this all about I can start the sql server service with the same account i'm trying to start the agent.
    Reply With Quote Reply With Quote
  2. 06-15-2005, 11:56 AM #2
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188
    Fixed it, the BUILTIN\Administrators didnt have sysadmin roll, applied that and it started.

    Reply With Quote Reply With Quote
  3. 06-15-2005, 01:04 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Better to add 'nt authority\system' in sql admin role, that way you don't have to give sa rights to all windows local admins.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules