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


SQL Server Agent won't start


SQL Server Agent won't start

Author
Message
Omoba
Omoba
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 263
I'm trying to configure mail notifications on a job, and i read up a few things online which i had already done and then i restarted the SQL Server Agent as advised, but it would not restart. Right now, it shows beside it's icon as SQL Server Agent(Agent XP's disabled). when i try to start it it comes up with this error
"Unable to start service SQLSERVERAGENT on server MyServ.

Additonal Information:
The SQLSERVERAGENT service on MyServ started and then stopped. (Object Explorer)"

Any ideas what i might have done wrong / the problem and possible solutions?

thanks

------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!Cool
thecosmictrickster@gmail.com
thecosmictrickster@gmail.com
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3720 Visits: 939
What does it say in the SQL Server ERRORLOG and the SQL Agent Log?

By default they are in ...\MSSQL.1\MSSQL\LOG (initial bit depends on drive, folder where you installed SQL Server) for a default instance.



Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Omoba
Omoba
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 263
these lines are from the records that read Error Log in the EventClass Column

2007-07-19 13:03:24.54 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.


2007-07-19 13:03:24.54 spid51 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.


2007-07-19 13:03:24.55 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!Cool
Greg D-550251
Greg D-550251
SSC Veteran
SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)

Group: General Forum Members
Points: 212 Visits: 189
Can you post the contents of your ..\MSSQL\LOG\SQLAGENT.OUT file too please.
Big Data Man
Big Data Man
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2454 Visits: 750
Hi,

You'll need to enable the Agent XP's by using following:

sp_configure 'show advanced options','1'
RECONFIGURE
go

sp_configure 'Agent XPs','1'
RECONFIGURE
go

This will enable Agent XP's and SQL Server Agent should start.

Thanks,
Phillip Cox
MCITP - DBAdmin
Omoba
Omoba
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 263
here is the content of SQLAgent.out

2008-03-07 10:23:33 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]
2008-03-07 10:23:33 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
2008-03-07 10:23:33 - ! [298] SQLServer Error: 2, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [SQLSTATE 08001]
2008-03-07 10:23:33 - ! [000] Unable to connect to server 'Starwars'; SQLServerAgent cannot start
2008-03-07 10:24:03 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]
2008-03-07 10:24:03 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
2008-03-07 10:24:03 - ! [298] SQLServer Error: 2, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [SQLSTATE 08001]
2008-03-07 10:24:03 - ! [382] Logon to server 'Starwars' failed (DisableAgentXPs)
2008-03-07 10:24:04 - ? [098] SQLServerAgent terminated (normally

------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!Cool
Big Data Man
Big Data Man
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2454 Visits: 750
Hi,

have you enabled remote connections via the Surface Area Configuration tool?

Thanks,
Phillip Cox
MCITP - DBAdmin
Omoba
Omoba
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 263
thanks's Phillip,
what database should i run this against? msdb?

[color=blue]sp_configure 'show advanced options','1'
RECONFIGURE
go

sp_configure 'Agent XPs','1'
RECONFIGURE
go

This will enable Agent XP's and SQL Server Agent should start.[/color]

------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!Cool
Big Data Man
Big Data Man
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2454 Visits: 750
Hey,

It's a master database query.

Thanks,
Phillip Cox
MCITP - DBAdmin
Omoba
Omoba
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 263
Hi Phillip,
this was displayed on the result pane after i ran the block of code against the master database.

Remote connections are enabled and i have tried to start SQLSERVERAGENT to no avail.

------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!Cool
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