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 SQL server agent is starting. Try again later. Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 22, 2013 9:31 AM
Points: 2, Visits: 31
Hello. I have a SQL 2000 SP4 that has this problem with the job since 15/07/2013. Look pretty and we have activated fibers NT mode or anything like that. The server was shut down on 15 and 16 present this problem without any configuration changes made ​​or anything like that.
This server functions as a replication publisher another 5 and as expected they are not replicating the data.
Thank you very much for any help you can give me.

regards
Post #1476055
Posted Monday, July 22, 2013 9:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
your post isn't clearly written. You mentioned fibers, but you say you activated them. Did you mean you haven't?

You haven't really given enough information about what is or is not working. Something tried to run, but SQL Server Agent wasn't running, or was stuck starting. Can you provide more details about what is wrong, or what else appeared in the log?

Also, please don't use the subject line as part of your post. Please write all information so we can easily follow what happened.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1476079
Posted Monday, July 22, 2013 9:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 22, 2013 9:31 AM
Points: 2, Visits: 31
hello. sorry but my English is not very good.

I'm not using NT fibers.
The agent appears to be running, but not run the job.
when trying to run the job manually error 14258 appears.
if you try to stop the agent, is in stopping state but never does. never appears as stopped

I hope I was more clear. Thanks for answering
Post #1476087
Posted Monday, July 22, 2013 9:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:19 AM
Points: 42, Visits: 254
It is very hard to remember all the error codes. If you paste or upload the errors, it would be much easier and helpful.

Refer @
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4265278f-8d0e-4cf3-87db-ed9b037e6cc3/error-14258-cannot-perform-this-operation-while-sqlserveragent-is-starting-try-again-later

I think similar kind problem.
Post #1476094
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse