June 1, 2009 at 1:10 pm
Ok, so I currently am having some issues with one of my prod sql servers. It was powered down by the SA team this past weekend and moved. They turned it back on and things seemed to start normally. The databases are all accessible from their perspective software packages. I did however notice that no jobs have been ran at all today. So I try to view the history on one of them and get the following message:
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
Now I have scowered the internet looking for information on this error. I have found all sorts of little tid bits here and there but none of them hold water for my particular instance. I am using SQL Server 2000 SP3...and no lightweight pooling/fiber mode. Also the account for this has not changed in at least 2 years. So I don't think that is the problem.
Things I have checked so far:
- Registry settings and user permissions.
- Starting SQL Server Agent by command line and piping out to a log file
- DBCC SQLPERF(umsstats) *Numbers posted below*
- EXEC sp_configure to check lightweight pooling.(Pooling = 0)
If there is something that I have missed, please let me know.
I compare being a DBA to that of Smokey The Bear. Helping to prevent wildfires in your forest of servers and applications.
June 1, 2009 at 1:18 pm
The physical location of the server changed?
Is the server still in the same domain?
June 1, 2009 at 1:33 pm
My apologies...when I say move...I mean they moved the cabinet from one room to another.
I compare being a DBA to that of Smokey The Bear. Helping to prevent wildfires in your forest of servers and applications.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply