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.
hi Trevor, Trevor Rutter wrote: > 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? > > 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
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 "Andrea Montanari" wrote: > hi Trevor, > Trevor Rutter wrote: > > 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? > > > > > 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 > > >
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.
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. "Trevor Rutter" wrote: > 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. > >
