Newbie Q setting up MSDE

Hello. I've installed MSDE (Win2k machine, running asp.net on localhost),
and it says 'Not Connected' when I mouseover the icon in the system tray. I
opened the SQL Server service manager, and there are two empty fields-
Server and Services. Please, what do I put in these fields? Also, what
connection string would I use with MSDE. Thanks a lot
Justin Dutoit
hi Justin,
"Justin Dutoit" <anon@.anon.com> ha scritto nel messaggio
news:%23Gr48BqqEHA.3988@.tk2msftngp13.phx.gbl
> Hello. I've installed MSDE (Win2k machine, running asp.net on
> localhost), and it says 'Not Connected' when I mouseover the icon in
> the system tray. I opened the SQL Server service manager, and there
> are two empty fields- Server and Services. Please, what do I put in
> these fields? Also, what connection string would I use with MSDE.
> Thanks a lot
> Justin Dutoit
please verify, using the services applet (control panel->performance and
maintenance->administrative tools->services [on XP] , control
panel->administrative tools->services [on Win2k]) that your MSDE instance is
currently up and running...
you can then try typing in the service name of your MSDE instance to manage
it...
MSDE installs by default disabling network protocols and this can be an
issue for some ODBC related functions and, sometime, the SQL Server
instances are not enlisted by the Service Manager, as reported in
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply