Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server Agent won't start Expand / Collapse
Author
Message
Posted Thursday, March 6, 2008 9:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, 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!!!
Post #465265
Posted Thursday, March 6, 2008 3:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:13 PM
Points: 2,665, Visits: 840
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
Post #465534
Posted Friday, March 7, 2008 3:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, 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!!!
Post #465698
Posted Friday, March 7, 2008 3:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 4:57 AM
Points: 204, Visits: 189
Can you post the contents of your ..\MSSQL\LOG\SQLAGENT.OUT file too please.
Post #465705
Posted Friday, March 7, 2008 4:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 4, 2014 12:52 PM
Points: 2,153, Visits: 662
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
Post #465709
Posted Friday, March 7, 2008 4:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, 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!!!
Post #465710
Posted Friday, March 7, 2008 4:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 4, 2014 12:52 PM
Points: 2,153, Visits: 662
Hi,

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

Thanks,
Phillip Cox
MCITP - DBAdmin
Post #465711
Posted Friday, March 7, 2008 4:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, 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!!!
Post #465717
Posted Friday, March 7, 2008 4:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 4, 2014 12:52 PM
Points: 2,153, Visits: 662
Hey,

It's a master database query.

Thanks,
Phillip Cox
MCITP - DBAdmin
Post #465723
Posted Friday, March 7, 2008 5:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, 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!!!
Post #465769
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse