Error 14258 SqlServerAgent is Starting

I am running SQL Server 2000. I was trying to implement a Database Maintence Plan to do the reorgznize data and index pages on database 'MYDB' and received the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
.....
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. Thanks!|||Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.