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

Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later Expand / Collapse
Author
Message
Posted Sunday, November 2, 2008 1:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 13, 2014 6:57 PM
Points: 148, Visits: 640
This just started happening with the time change. When i try to look at the properties of my scheduled jobs, i get the error:

Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later

I've tried rebooting the server to no avail, please help.

Post #595528
Posted Sunday, November 2, 2008 4:48 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 2:13 AM
Points: 175, Visits: 746
Hi,

Is there anything in your SQLAGent.out files that can give you a clue? Have you changed the startup account lately (one of those things that could have been changed a long time ago but the change did not come in effect until the service was restared).

Try to start the agent from the command line and pipe the result (and then check the agenterror.out for clues):

sqlagent.exe -c -v >C:\agenterror.out

You can also try the steps in http://support.microsoft.com/kb/322140 although the article specifies another error.

HTH!

/Elisabeth


elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Post #595541
Posted Monday, November 3, 2008 7:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 13, 2014 6:57 PM
Points: 148, Visits: 640
Thanks Elisabeth. What we ended up doing was rebooting our sql farm of about 30 sql servers, this must have put the time back in synch and jobs started running normally again. Weird.
Post #595814
Posted Thursday, November 20, 2008 9:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 20, 2008 9:27 AM
Points: 1, Visits: 1
I started getting this error (Error 14258: Cannot perform this operation while SQLServerAgent is starting. try again later) this morning, afterrebooting to finish installing an external drive. I have checked, and it is already in thread mode, with lightweight pooling set to 0. I ran a reconfigure in Query analyzer just to be sure, and that confirmed that lightweight pooling was already off - it returned "lightweight pooling changed from 0 to 0." Therer have been no account changes in 3 years on this server.

This is the MOM database server, and I need the extra space to back up some logs so I can do anything to keep the stupid server from running out of space - a chronic problem with this pig (MOM). Is there *any* reason installing an external drive should hose SQL?

- Everett
Post #605923
Posted Friday, August 8, 2014 1:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 1, Visits: 94
Check any db is in recovery mode
Post #1601321
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse