Discussion:
SQL Server Agent hangs on startup
(too old to reply)
Trevor Rutter
2008-06-18 15:38:01 UTC
Permalink
We have tried to upgrade some clients from msde 1 to msde 2000 and although
they seem succeed when we start the application this fails.

We then tried to rollback the application by using an XP restore point and
reinstating the .MDF and .LDF files. On reboot the system appears to be
working and the application runs but SQL Server Agent goes into a state of
starting and never successfully starts up. Obvioulsy this prevents us from
running any SQL jobs.

Could anyone help with the problem.
Andrea Montanari
2008-06-19 10:01:56 UTC
Permalink
hi Trevor,
Post by Trevor Rutter
We have tried to upgrade some clients from msde 1 to msde 2000 and
although they seem succeed when we start the application this fails.
which application?
what kind of exceptions?
Post by Trevor Rutter
We then tried to rollback the application by using an XP restore
point and reinstating the .MDF and .LDF files. On reboot the system
appears to be working and the application runs but SQL Server Agent
goes into a state of starting and never successfully starts up.
Obvioulsy this prevents us from running any SQL jobs.
what does the SQLAGENT.OUT file report?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply
Trevor Rutter
2008-06-19 12:11:01 UTC
Permalink
Hi Andrea

The following appears int SQLAgent.out

13/06/2008 16:10:26 - ? [129] SQLServerAgent starting under Windows NT
service control
13/06/2008 16:10:26 - ? [393] Waiting for SQL Server to recover databases...
13/06/2008 16:10:28 - ? [100] Microsoft SQLServerAgent version 7.00.839 (x86
unicode retail build) : Process ID 912
13/06/2008 16:10:28 - ? [101] SQL Server BOCL_SR01 version 7.00.842 (0
connection limit)
13/06/2008 16:10:28 - ? [102] SQL Server ODBC driver version 3.81.9030
13/06/2008 16:10:28 - ? [103] NetLib being used by driver is DBMSSHRN.DLL;
Local host server is (local)
13/06/2008 16:10:28 - ? [310] 2 processor(s) and 248 MB RAM detected
13/06/2008 16:10:28 - ? [339] Local computer is BOCL_SR01 running Windows NT
5.1 (2600) Service Pack 1

I have looked at some earlier sqlagent files and similar messages appear in
them
Post by Andrea Montanari
hi Trevor,
Post by Trevor Rutter
We have tried to upgrade some clients from msde 1 to msde 2000 and
although they seem succeed when we start the application this fails.
which application?
what kind of exceptions?
Post by Trevor Rutter
We then tried to rollback the application by using an XP restore
point and reinstating the .MDF and .LDF files. On reboot the system
appears to be working and the application runs but SQL Server Agent
goes into a state of starting and never successfully starts up.
Obvioulsy this prevents us from running any SQL jobs.
what does the SQLAGENT.OUT file report?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply
Trevor Rutter
2008-06-20 08:58:01 UTC
Permalink
bit more info

When I try to start a job (manually) I get the following messages

Microsoft SQL-DMO(ODBC SQL state 42000)

Error 14258: Cannot perform this operation while SQLServerAgent is starting.
Please try again later.
Trevor Rutter
2008-06-23 07:09:00 UTC
Permalink
Got a response on the server community and this has worked

Fix detailed in KB article http://support.microsoft.com/kb/322140

The rll files seem to have been corrupted, once I replaced these with saved
versions then SQL Agent started and ran successfully.
Post by Trevor Rutter
bit more info
When I try to start a job (manually) I get the following messages
Microsoft SQL-DMO(ODBC SQL state 42000)
Error 14258: Cannot perform this operation while SQLServerAgent is starting.
Please try again later.
Loading...