SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Agent stops and cannot start


SQL Server Agent stops and cannot start

Author
Message
Lester Policarpio
Lester Policarpio
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1781 Visits: 2459
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
MarkusB
MarkusB
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10401 Visits: 4208
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
Lester Policarpio
Lester Policarpio
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1781 Visits: 2459
thanks very much Marcus!!!!!! works very fine the SQL Server Agent starts again ill take note this information

"-=Still Learning=-"

Lester Policarpio
agil
agil
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 10
Hola, Yo tenía el mismo problema y también me funcionó. Gracias.
cenkyurtseven
cenkyurtseven
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 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.
john 70005
john 70005
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 9
Unable to Start SQL Server Agent: it's greyed out and there are no options for it.

Running Windows-7 Pro 32 bit, with SQL Server 2008 R2. Apparently unable to install Management Studio or maybe it's already installed.

Cannot create a user=> "NT Authority/System" as those characters are not allowed in the username. The is only 1 user acount => john with Admin privildges. How do I create this NT Authority account and configure it?

Thanks
sanjivvinaik
sanjivvinaik
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 517
Try these 2 way and share if it works...

1st way

USE master

CREATE LOGIN [NT AUTHORITY\SYSTEM] From Windows with default_database = [master], DEFAULT_LANGUAGE=[us_english]

2nd way

If this account is missing under Security/Logins then please add the login by the following syntax:

sp_grantlogin 'NT AUTHORITY\SYSTEM' if this fails then try this sp_grantlogin '[NT AUTHORITY\SYSTEM]'

then

make sure the default database for ' NT AUTHORITY\SYSTEM ' login is master.

then

Go to 'Security->Logins' in Management Studio, open the properties window of ' NT AUTHORITY\SYSTEM ' login, at the 'User Mapping' tab, map the appropriate database and select the required database role for each database.

Sanjiv
HTH
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search