Installing MSDE

Hello,
JOe here,
I am doing my best to install the MSDEsp3 that is included
in Office 2003 Pro I also downloaded the MSDE2000A from MS
site. When I try to install it it decides to stop
intalling and gives this error.
(A strong SA pasword is required for security reasons.
Please use SAPWD switch to supply the same. please refer
ro the readme for more details. Setup will now exit)
Well... I refered and i looked but didn't see a thing.
So ... I came here.
any help here please
Joe
hi Joe,
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:749001c494d9$290e17a0$a501280a@.phx.gbl...
> Hello,
> JOe here,
> I am doing my best to install the MSDEsp3 that is included
> in Office 2003 Pro I also downloaded the MSDE2000A from MS
> site. When I try to install it it decides to stop
> intalling and gives this error.
> (A strong SA pasword is required for security reasons.
> Please use SAPWD switch to supply the same. please refer
> ro the readme for more details. Setup will now exit)
> Well... I refered and i looked but didn't see a thing.
> So ... I came here.
you have to provide this information as a parameter like
c:\...\>setup.exe (other params) SAPWD="your strong pwd" (other params) /L*v
"c:\msdelog.txt"
you can see all parameters synopsis at
http://msdn.microsoft.com/library/de...stsql_84xl.asp ,
where futher info are presented too
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
|||Andrea, Thanks for your reply,
But I haven't a clue what this is.
I am like in a dark room with my hands over my eyes with
this one.
Where do you start to install this? In a command prompt?
I have failed to tell you (I guess) that I am new to this
SQL.
I have never installed anything from a command prompt
before..
Ok, Let me ask this question please?
I bought about a year ago, the Office XP Developer edition
of Office. Inside this package was about 6 CD's and one of
them says SQL server 2000 is this the real thing or do I
need more? I installed this once and was in dire need of
information to get it to work but of course I didn't get
it. So.. I uninstalled it.
I really need some guidence here please.
Thanks very much for your time Pison
Joe
>--Original Message--
>hi Joe,
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:749001c494d9$290e17a0$a501280a@.phx.gbl...
included[vbcol=seagreen]
MS
>you have to provide this information as a parameter like
>c:\...\>setup.exe (other params) SAPWD="your strong pwd"
(other params) /L*v
>"c:\msdelog.txt"
>you can see all parameters synopsis at
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/distsql/distsql_84xl.asp ,
>where futher info are presented too
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||hi Joe,
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:782901c49503$694226c0$a501280a@.phx.gbl...
> Andrea, Thanks for your reply,
> But I haven't a clue what this is.
> I am like in a dark room with my hands over my eyes with
> this one.
> Where do you start to install this? In a command prompt?
> I have failed to tell you (I guess) that I am new to this
> SQL.
> I have never installed anything from a command prompt
> before..
> Ok, Let me ask this question please?
> I bought about a year ago, the Office XP Developer edition
> of Office. Inside this package was about 6 CD's and one of
> them says SQL server 2000 is this the real thing or do I
> need more? I installed this once and was in dire need of
> information to get it to work but of course I didn't get
> it. So.. I uninstalled it.
> I really need some guidence here please.
ok... =;-D
you have to install MSDE providing some parameters... this can be done
providing an INI file the setup bootstrapper will read, or just pass them as
command line parameters, and this is the way I do prefer and suggest...
and yes... you have to run the setup.exe from a command prompt...
so go this way...
locate your MSDE installer directory and provide all required params...
c:\...\>setup.exe
add the sa pwd as
SAPWD="your pwd"
we don't want to install a named instance of MSDE, as it will be the default
instance, so omit relative param...
we do not want to specify custom directories for binaries and data files,
and they will point to Program Files\..., so omit relative param...
we do wan to to allow network connections, so specify relative param as
DISABLENETWORKPROTOCOLS=0
se do want to allow SQL Server authenticated connections instead of trusted
WinNT connections only, so specify relative param as
SECURITYMODE=SQL
and finally, we do want the setup to log all install operation to a verbose
txt file
/L*v "c:\msdelog.txt"
the resulting command will be
c:\...\>setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL /L*v "c:\msdelog.txt"
and pelase do use the package you downloaded from the web, MSDE Web Release
A, as it is updated at the last service pack level
for your convenience, you can download SQL Server Books On Line, the online
documentation, from
http://www.microsoft.com/sql/techinf...000/books.asp, where you
can find lot of information about the product
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
|||Hello Andrea,
Ok,someone told me that SQL was easier than Access. I
don't think so...
locate your MSDE installer directory and provide all
required params...
c:\...\>setup.exe
add the sa pwd as >>>>>> where does this go?
SAPWD="your pwd"
In here? >>>c:\...\>setup.exe
I have no Idea?
Ok here is the path to the MSDE on C:\
C:\MSDERela\setup.exe
Now how does this work with this >>> SAPWD="your pwd"
1. Open CMD ?
2. Type What?
3. Sorry I am still lost?
4. I failed to read the rest of your post because I got
lost here.
5. Why is this so damn difficult.
Signed Frustrated Joe

>--Original Message--
>hi Joe,
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:782901c49503$694226c0$a501280a@.phx.gbl...
this[vbcol=seagreen]
edition[vbcol=seagreen]
of
>ok... =;-D
>you have to install MSDE providing some parameters...
this can be done
>providing an INI file the setup bootstrapper will read,
or just pass them as
>command line parameters, and this is the way I do prefer
and suggest...
>and yes... you have to run the setup.exe from a command
prompt...
>so go this way...
>locate your MSDE installer directory and provide all
required params...
>c:\...\>setup.exe
>add the sa pwd as
> SAPWD="your pwd"
>we don't want to install a named instance of MSDE, as it
will be the default
>instance, so omit relative param...
>we do not want to specify custom directories for binaries
and data files,
>and they will point to Program Files\..., so omit
relative param...
>we do wan to to allow network connections, so specify
relative param as
> DISABLENETWORKPROTOCOLS=0
>se do want to allow SQL Server authenticated connections
instead of trusted
>WinNT connections only, so specify relative param as
>SECURITYMODE=SQL
>and finally, we do want the setup to log all install
operation to a verbose
>txt file
> /L*v "c:\msdelog.txt"
>the resulting command will be
>c:\...\>setup.exe SAPWD="your pwd"
DISABLENETWORKPROTOCOLS=0
>SECURITYMODE=SQL /L*v "c:\msdelog.txt"
>and pelase do use the package you downloaded from the
web, MSDE Web Release
>A, as it is updated at the last service pack level
>for your convenience, you can download SQL Server Books
On Line, the online
>documentation, from
>http://www.microsoft.com/sql/techinf...tdoc/2000/book
s.asp, where you
>can find lot of information about the product
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||hi Joe,
don't worry =;-D
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:033a01c49520$cea94b70$a401280a@.phx.gbl...
> Hello Andrea,
> Ok,someone told me that SQL was easier than Access. I
> don't think so...
don't think so too =;-D

> locate your MSDE installer directory and provide all
> required params...
> c:\...\>setup.exe
> add the sa pwd as >>>>>> where does this go?
> SAPWD="your pwd"
> In here? >>>c:\...\>setup.exe
> I have no Idea?
> Ok here is the path to the MSDE on C:\
> C:\MSDERela\setup.exe
> Now how does this work with this >>> SAPWD="your pwd"
>
yep.
open a command window.. navigate to tha folder, and type the full command
like
C:\MSDERela\>setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL /L*v "C:\msdelog.txt"
on the same line =;-D
this will install a default instance of MSDE, with enabled network
protocols, allowing SQL Server authenticated connections too, with the "sa"
SQL Server special account password of "your pwd"
the installation will be logged in the C:\msdelog.txt file...
again, you can see the full explanation of each parameter at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
regards
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
|||Hello Andrea
Ok This is much better ;) I will give this a try
I will let you know
JOe
>--Original Message--
>hi Joe,
>don't worry =;-D
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:033a01c49520$cea94b70$a401280a@.phx.gbl...
>don't think so too =;-D
>
>yep.
>open a command window.. navigate to tha folder, and type
the full command
>like
>C:\MSDERela\>setup.exe SAPWD="your pwd"
DISABLENETWORKPROTOCOLS=0
>SECURITYMODE=SQL /L*v "C:\msdelog.txt"
>on the same line =;-D
>this will install a default instance of MSDE, with
enabled network
>protocols, allowing SQL Server authenticated connections
too, with the "sa"
>SQL Server special account password of "your pwd"
>the installation will be logged in the C:\msdelog.txt
file...
>again, you can see the full explanation of each parameter
at
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/distsql/distsql_84xl.asp
>regards
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||I am getting the response MSDERela is not a recognized
internal command?
And the spinning wheel goes round and round ;)
Thanks
Joe

>--Original Message--
>hi Joe,
>don't worry =;-D
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:033a01c49520$cea94b70$a401280a@.phx.gbl...
>don't think so too =;-D
>
>yep.
>open a command window.. navigate to tha folder, and type
the full command
>like
>C:\MSDERela\>setup.exe SAPWD="your pwd"
DISABLENETWORKPROTOCOLS=0
>SECURITYMODE=SQL /L*v "C:\msdelog.txt"
>on the same line =;-D
>this will install a default instance of MSDE, with
enabled network
>protocols, allowing SQL Server authenticated connections
too, with the "sa"
>SQL Server special account password of "your pwd"
>the installation will be logged in the C:\msdelog.txt
file...
>again, you can see the full explanation of each parameter
at
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/distsql/distsql_84xl.asp
>regards
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||=;-D
"Joe" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7a4d01c4952d$ffaa8a10$a601280a@.phx.gbl...
> I am getting the response MSDERela is not a recognized
> internal command?
at your DOS command prompt type
CD\
it must appear
C:\>
change again directory to the folder containing the setup.exe file, you said
the dir is named MSDERela, so
CD MSDERela
now it must appear
C:\MSDERela>
now type the setup command string:
setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL /L*v
"c:\msdelog.txt"
hey... this is standard console interaction =;-D
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
|||hey... this is standard console interaction =;-D
I am not exactly sure how to take that?
Could you please type out the string for DOS prompt again.
I just do not get your meaning CD.It is not on a CD
Yes on my c drive the folder MSDERela is there and the
setup.exe is inside that folder
I am a newbie yes but just here.
If you go here
www.animocracy.com
You can see the extensive work I have done with CDO and
other MVP's there pison
Also www.Slovaun.com
amd www.Immoralbalance.com
There are many more and I do contribute to the MVP sites
But as I have mentioned I do not use the CMD that often.
These sites didn't get there by accident. Ok so I am not
afraid of stepping into deep water ;-)
You are speaking way above my head in some areas you
cannot assume I understand your terminology.
So... I do feel a little embarrassed that I cannot even
install this much less use it ;(
Thanks Andrea
Joe
>--Original Message--
>=;-D
>"Joe" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:7a4d01c4952d$ffaa8a10$a601280a@.phx.gbl...
>at your DOS command prompt type
>CD\
>it must appear
>C:\>
>change again directory to the folder containing the
setup.exe file, you said
>the dir is named MSDERela, so
>CD MSDERela
>now it must appear
>C:\MSDERela>
>now type the setup command string:
>setup.exe SAPWD="your pwd" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL /L*v
>"c:\msdelog.txt"
>hey... this is standard console interaction =;-D
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>