MSDE Newbie Blooper

Another newbie here, hope yaw dont mind!
Yes I am redneck newbie
I have been using access for a few years and have decided to further
educate myself(untrain) and start allover withh SQL. I have the developers
edition of SQL 2000 and VisualStudio.net 2003, I did look at SQL 2005
Express. I know the newer the better, but as of this time I cannot afford to
take the plung for the devlopers edition of SQL 2005. So back to my
questions.
I am learning here so take it easy on me. I got SQL 2000 loaded and I can
access the server, make tables,etc,
I cant get MSDE to work in VS for some reason?(dont know what I am doing
probably) Every time I lanch VS and try to connect to the database, I get
"VS can only connect using MSDE,etc".I did download MSDE2000 and installed
as per instruction went to a command prompted and entered Setup.exe /qb+
INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR
SA PASSWORD>
as told, an error was promtped, saying to go to the control panel to make
changes?
-not what the instructions said-
, anyhow, to make it short, can someone point me in the right direction to
make this work so I can start doodling in my mind with what I have ahead of
me..
I have order a few books to enrich my tastebuds with whats ahead, but I like
jumping in over my head first..
Thanks in advance
David W
hi David,
DavidW wrote:
>...
> I cant get MSDE to work in VS for some reason?(dont know what I am
> doing probably) Every time I lanch VS and try to connect to the
> database, I get "VS can only connect using MSDE,etc".
I think to rember that the Standard edition of VS2003 only allowed to
connect to MSDE and not to full blown editions...

>I did download
> MSDE2000 and installed as per instruction went to a command prompted
> and entered Setup.exe /qb+ INSTANCENAME=VSDOTNET
> DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD>
> as told, an error was promtped, saying to go to the control panel to
> make changes?
> -not what the instructions said-
> , anyhow, to make it short, can someone point me in the right
> direction to make this work so I can start doodling in my mind with
> what I have ahead of me..
try adding the
/L*v "c:\MsdeLog.txt"
parameter to your setup syntax in order to enable verbose logging of the
installation process.. this will result in an about 2mb text file (for a
succesfull installation) you can inspect in case of troubles..
seek for
RETURN VALUE 3
entries, and about 10 lines before each entry some (sometime cryptinc)
description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply