SQL Server Agent stops and cannot start

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » SQL Server Agent stops and cannot start

SQL Server Agent stops and cannot start

Rate Topic

Display Mode

Topic Options

Author

Message

Lester Policarpio

Posted Monday, October 08, 2007 3:53 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:36 PM
Points: 398, Visits: 2,407

My SQL Server Agent stops and cannot be started when viewing the error logs it displays the following errors:

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

000] Unable to connect to server '(local)'; SQLServerAgent cannot start

[098] SQLServerAgent terminated (normally)

tried starting using the Services in control panel but to no avail what could be the problem? dunno what errors are saying....

There are no errors written in the event viewer only in the SQL Server Agent Error Log although this happened in my dummy database (testing server) i want to know what happened in my SQL Server agent

"-=Still Learning=-"

Lester Policarpio

Post #407905

MarkusB

Posted Monday, October 08, 2007 4:56 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 4,222, Visits: 3,881

Looking at the error message my first guess would be that you removed the Builtin\Administrators and now the local system acocunt can't login to the server.
If that's the case add a windows login 'NT Authority\System' and make it member of tyhe sysadmin role.

Hope this helps
Markus

Markus Bohse

Post #407916

Lester Policarpio

Posted Monday, October 08, 2007 6:56 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:36 PM
Points: 398, Visits: 2,407

thanks very much Marcus!!!!!! works very fine the SQL Server Agent starts again ill take note this information

"-=Still Learning=-"

Lester Policarpio

Post #408246

agil

Posted Friday, February 06, 2009 1:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 13, 2012 9:37 AM
Points: 3, Visits: 10

Hola, Yo tenía el mismo problema y también me funcionó. Gracias.

Post #651950

cenkyurtseven

Posted Tuesday, October 18, 2011 1:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 19, 2011 11:28 AM
Points: 1, Visits: 19

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.

Post #1192447

« Prev Topic | Next Topic »

Permissions