Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Rio de Janeiro, Brazil
    Posts
    20

    Unanswered: SQLAgent Service does not starts

    Please Help!!!

    the following error atempts to sqlserver agent:

    error 1- "[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000]"

    error 2- "SQL Server Agent could not be started (Reason: Unable to connect to server '(local)'; SQL Server Agent cannot start)"

    the other services are OK, only SQLAgent does not start.

    im using Windows 2000 Server SP3 and SQL Server Enterprise Edition SP2

    the service startup account is system account
    Oracle 9i & SQL Server 2000 - DBA
    Rio de janeiro - Brazil
    lsantos.rj@globo.com

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Some one has deleted the "Builtin\Administrators" login. This is the account used by the SQL Server Agent when running under the local NT account.

    The fix:
    Create a new login. the Name of the login is "Builtin\Administrators". Click on "OK". You should get a message back stateing "It has been detected that this login has permissions in specific database(s) - the login will have access to these databases now" click on "OK"

    You should be set to go.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    You could also just manipulate the login that the agent useses to login.
    If you are running in win2000 go to the services panel and find the sql server agent. Right click on it and go to properties. Then go to the login tab and enter the login info. Please note that the login must have the permisions of system admin or you will have problems.
    Regards Jim





    Originally posted by Paul Young
    Some one has deleted the "Builtin\Administrators" login. This is the account used by the SQL Server Agent when running under the local NT account.

    The fix:
    Create a new login. the Name of the login is "Builtin\Administrators". Click on "OK". You should get a message back stateing "It has been detected that this login has permissions in specific database(s) - the login will have access to these databases now" click on "OK"

    You should be set to go.

  4. #4
    Join Date
    Sep 2002
    Location
    Rio de Janeiro, Brazil
    Posts
    20
    i tried both solutions and all worked ok !!!

    the problem was that i got the database already installed, and they used the system as the login to start up the services.

    thaks u all !!!


    Originally posted by JDionne
    You could also just manipulate the login that the agent useses to login.
    If you are running in win2000 go to the services panel and find the sql server agent. Right click on it and go to properties. Then go to the login tab and enter the login info. Please note that the login must have the permisions of system admin or you will have problems.
    Regards Jim
    Oracle 9i & SQL Server 2000 - DBA
    Rio de janeiro - Brazil
    lsantos.rj@globo.com

Posting Permissions

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