HELP! Enterprise Manger closes when viewing database properties

If I right click on a database and choose properties, SQL server Enterprise
Manager just closes. The following error then shows up in the event log.
Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Date: 12/7/2003
Time: 5:11:58 PM
User: N/A
Computer: NPR_Broadcast1
Description:
The application, mmc.exe, generated an application error The error occurred
on 12/07/2003 @. 17:11:58.687 The exception generated was c0000005 at address
4247B7AB (<nosymbols>)
Any Help would be appreciated!
thanks,
Shelly LangleyWhat is the level of your SP?
Are there other processes?
"ShellyL" <SLangley@.Yahoo.com> a écrit dans le message de
news:OmtgDySvDHA.2456@.TK2MSFTNGP12.phx.gbl...
> If I right click on a database and choose properties, SQL server
Enterprise
> Manager just closes. The following error then shows up in the event log.
> Event Type: Information
> Event Source: DrWatson
> Event Category: None
> Event ID: 4097
> Date: 12/7/2003
> Time: 5:11:58 PM
> User: N/A
> Computer: NPR_Broadcast1
> Description:
> The application, mmc.exe, generated an application error The error
occurred
> on 12/07/2003 @. 17:11:58.687 The exception generated was c0000005 at
address
> 4247B7AB (<nosymbols>)
> Any Help would be appreciated!
> thanks,
> Shelly Langley
>|||Try right clicking the database , go to View and select detail (instead of
Taskpad)... Sometimes viewing taskpad gives the error you mention...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ShellyL" <SLangley@.Yahoo.com> wrote in message
news:OmtgDySvDHA.2456@.TK2MSFTNGP12.phx.gbl...
> If I right click on a database and choose properties, SQL server
Enterprise
> Manager just closes. The following error then shows up in the event log.
> Event Type: Information
> Event Source: DrWatson
> Event Category: None
> Event ID: 4097
> Date: 12/7/2003
> Time: 5:11:58 PM
> User: N/A
> Computer: NPR_Broadcast1
> Description:
> The application, mmc.exe, generated an application error The error
occurred
> on 12/07/2003 @. 17:11:58.687 The exception generated was c0000005 at
address
> 4247B7AB (<nosymbols>)
> Any Help would be appreciated!
> thanks,
> Shelly Langley
>|||Thanks for the replies! I got shipped out of the office this week, so I
wasn't able to try anything yet, but I need to get on it right away.
I'll let you know.
-S.L.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23MCiNtYvDHA.3436@.tk2msftngp13.phx.gbl...
> Try right clicking the database , go to View and select detail (instead of
> Taskpad)... Sometimes viewing taskpad gives the error you mention...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "ShellyL" <SLangley@.Yahoo.com> wrote in message
> news:OmtgDySvDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > If I right click on a database and choose properties, SQL server
> Enterprise
> > Manager just closes. The following error then shows up in the event
log.
> >
> > Event Type: Information
> > Event Source: DrWatson
> > Event Category: None
> > Event ID: 4097
> > Date: 12/7/2003
> > Time: 5:11:58 PM
> > User: N/A
> > Computer: NPR_Broadcast1
> > Description:
> > The application, mmc.exe, generated an application error The error
> occurred
> > on 12/07/2003 @. 17:11:58.687 The exception generated was c0000005 at
> address
> > 4247B7AB (<nosymbols>)
> >
> > Any Help would be appreciated!
> > thanks,
> > Shelly Langley
> >
> >
>|||Sorry for my ignorance, but SP? Other processes where?
Thanks,
SL
"Philippe RUELLO" <pruello@.tibco.fr> wrote in message
news:%23hAl3dWvDHA.2484@.TK2MSFTNGP09.phx.gbl...
> What is the level of your SP?
> Are there other processes?
>|||It doesn't seem to matter. Enterprise Manager just disappears whatever it's
on.
Any other ideas?
Thanks,
SL
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23MCiNtYvDHA.3436@.tk2msftngp13.phx.gbl...
> Try right clicking the database , go to View and select detail (instead of
> Taskpad)... Sometimes viewing taskpad gives the error you mention...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
>|||SQL Server Standard Edition
Product Version 8.00.760 (SP3)
Microsoft Management Console 1.2
Version 5(Build 2195: Service Pack 4)|||System seems ok,
does the error alwys happens on the same db?
"ShellyL" <SLangley@.Yahoo.com> a écrit dans le message de
news:OX3locVxDHA.2316@.TK2MSFTNGP10.phx.gbl...
> SQL Server Standard Edition
> Product Version 8.00.760 (SP3)
> Microsoft Management Console 1.2
> Version 5(Build 2195: Service Pack 4)
>|||It was happening with any DB. I just re-ran SP3 (actually 3a) and it seems
to have fixed it (4:48am).
Really weird.
Thanks,
Shelly Langley
"Philippe RUELLO" <pruello@.tibco.fr> wrote in message
news:ewnaFnVxDHA.2464@.TK2MSFTNGP12.phx.gbl...
> System seems ok,
> does the error alwys happens on the same db?
> "ShellyL" <SLangley@.Yahoo.com> a écrit dans le message de
> news:OX3locVxDHA.2316@.TK2MSFTNGP10.phx.gbl...
> > SQL Server Standard Edition
> > Product Version 8.00.760 (SP3)
> >
> > Microsoft Management Console 1.2
> > Version 5(Build 2195: Service Pack 4)
> >
> >
>

HELP! Can't connect to MSDE using Enterprise manger

I installed an instance (only one) of MSDE200 sp3a on one of the desktop machine (XP pro sp1), I would like to manage it by using the enterprise manager installed on another machine on the same network. I was getting the "SQL server does not exist or acce
ss denied" error. I am sure I have enter the proper login info and the MSDE is running.
Is there any configuration need to be done on the MSDE? any expert here can help me on this?
Thanks
Henry
hi Henry,
"Henry" <henryli1222@.msn.com> ha scritto nel messaggio
news:6AB45DD1-DA80-440E-B338-EA8F5467358F@.microsoft.com...
> I installed an instance (only one) of MSDE200 sp3a on one of the desktop
machine (XP pro sp1), I would like to manage it by using the enterprise
manager installed on another machine on the same network. I was getting the
"SQL server does not exist or access denied" error. I am sure I have enter
the proper login info and the MSDE is running.
> Is there any configuration need to be done on the MSDE? any expert here
can help me on this?
>
probably you installed the remote MSDE instance with the default parameter
which disable network protocols for it, not allowing remote connections to
that server...
please run svrnetcn.exe (Server Net Utility) on that server to verify the
desired network protocols are enabled...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, it works. It's possible to enable the network protocals for the MSDE 2000 installation?
|||Hi Henry,
You can do this by executing svrnetcn.exe.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:773EC08B-D846-4AB5-AA82-35034BD9375F@.microsoft.com...
> Thanks, it works. It's possible to enable the network protocals for the
MSDE 2000 installation?