Post reply

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

  • November 2, 2008 at 1:35 am

    #200721

    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.

  • November 2, 2008 at 4:48 am

    #892799

    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

  • November 3, 2008 at 7:52 am

    #893008

    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.

  • November 20, 2008 at 9:35 am

    #901135

    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

  • August 8, 2014 at 1:35 pm

    #1736539

    Check any db is in recovery mode

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply