[393] Waiting for SQL Server to recover databases...
We have a two node cluster running W2K and SQL2000. The agent starts, but we cannot access any of the jobs. It gives us the 14258 Agent is starting, try again later... error message. We know that this is not the case, we have waited several hours without it "starting". The SQL Agent log indicates that the agent is waiting on SQL Server to recover databases, but all of our databases are up. It is almost as if during startup a flag did not get set to indicate that a database was recovered.
Has anyone run across this before? If so, did you ever figure out how to fix it?
To stop "fiber mode" (Lightweight pooling)
To change from Fiber Mode simply perform the following in Query Analyzer then restart the SQL Services;
SP_CONFIGURE 'Allow Updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'Lightweight Pooling', 0
GO
RECONFIGURE WITH OVERRIDE
GO
