Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: Cannot Start SQL Server Agent

    I cannot start the SQL Server agent regardless of who I'm logged on as (even as domain admins).

    07/04/04 11:39:03 - ? [129] SQLServerAgent starting under Windows NT service control
    07/04/04 11:39:03 - ! [298] SQLServer Error: 18456, Login failed for user 'RSC\Administrator'. [SQLSTATE 28000]
    07/04/04 11:39:03 - ! [000] Unable to connect to server; SQLServerAgent cannot start
    07/04/04 11:39:03 - ? [098] SQLServerAgent terminated (normally)

    Anybody got any ideas. I've already checked the port...

    Its SQLServer 7 on Windows NT

    Lisa

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Cannot Start SQL Server Agent

    Originally posted by frazzled
    I cannot start the SQL Server agent regardless of who I'm logged on as (even as domain admins).

    07/04/04 11:39:03 - ? [129] SQLServerAgent starting under Windows NT service control
    07/04/04 11:39:03 - ! [298] SQLServer Error: 18456, Login failed for user 'RSC\Administrator'. [SQLSTATE 28000]
    07/04/04 11:39:03 - ! [000] Unable to connect to server; SQLServerAgent cannot start
    07/04/04 11:39:03 - ? [098] SQLServerAgent terminated (normally)

    Anybody got any ideas. I've already checked the port...

    Its SQLServer 7 on Windows NT

    Lisa

    were any passwords changed?

  3. #3
    Join Date
    Feb 2004
    Posts
    78
    frazzled is correct, you are seeing this because the password for the 'RSC\Administrator' has changed. Go into services, double click sql server agent and change the password to what the new password is. If you do not need the agent to access network drives I'd suggest having it log on as the local system account. Otherwise create a domain user with lower privilages than the administrator account.

    BTW, This is a pervasive forum, not a Sql Server forum.

    Hope this helps,
    Eric

  4. #4
    Join Date
    Oct 2011
    Posts
    1

    Assign User Rights to "NT AUTHORITY\SYSTEM"

    You may solve this problem by assigning user rights to the user: "NT AUTHORITY\SYSTEM".
    Follow these steps:
    Open "SQL Server Management Studio".
    Open "Security, and then Logins".
    Rightclick on user: "NT AUTHORITY\SYSTEM >> Properties".
    Select "Server Roles" tab, and check the "sysadmin" server role.
    You are done. SQL Server Agent will be started now.
    Last edited by cenkyurtseven; 10-18-11 at 16:46.

Posting Permissions

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