Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:
> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> > Hi,
> > I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
> 3a.
> > When I go to enterprise manager and click on (local) under server groups,
> > enterprise manager hangs and once that happens, all connections (query
> > analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> > sqlsvr.exe and then start the server again using the Service Manager. (If
> I
> > try to stop the server after ending mmc.exe, the status of the Server just
> > stays as "Stopping").
> > If I don't go to Enterprise Manager, everything works fine. Also, just
> in
> > case you're wondering, I DO NOT have tracing enabled.
> >
> > I used ProcExp from www.sysinternals.com and after clicking on (local)
> > with enterprise manager, I get the following data:
> >
> > 2 new events:
> > \BaseNamedObjects\Crypt32LogOff
> > \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> >
> > when i look at the threads, i get the following:
> > RPCRT4.DLLNdrRangeUnmarshall
> > msvcrt.dll!end thread
> >
> > Any thoughts/suggestions would be appreciated. Thanks.
>
>