Re: MSDE SAPWD Setup Error

#1

As the ReadMe specifies, a strong sapwd is required when installing an MSDE
instance starting with SP3. Always use SAPWD when installing and specify a
strong sa pwd.

If you wish to connect using Windows authentication then you do not need to
specify SECURITYMODE=sql, for non-Win98 if you do not specify this then it
uses Windows NT authentication. For Win98 the default is always SQL
authentication (meaning you have to specify the user and corresponding
password when connecting). More info on this can be found in
http://support.microsoft.com/default...N-US;Q319930#6 and
http://support.microsoft.com/default...;EN-US;q285097.

Sample command line to install MSDE, use latest MSDE SP3a in
http://www.microsoft.com/sql/downloads/2000/sp3.asp, download the files
necessary to install an MSDE SP3a instance. Please refer to section 3.7 of
the sp3Readme.htm for installation instructions, this is important as we
introduced new switches starting in SP3.

Quote:

setup.exe instancename=test securitymode=sql sapwd=foo /l*v c:\test.log

This will install an MSDE with instance name TEST using SQL authentication.
Note to use /l*v switch to create a verbose log, this will help you verify
if installation was succesful or if it failed at the end of setup.

sample on how to connect to server in the command line:

Quote:

net start MSSQL$TEST
osql -Usa -Pfoo -S<machine name>\TEST
1> select @@version

2> go
this should show that you have MSDE version 8.00.761 for SP3a.
1> exit

Quote:

net stop MSSQL$TEST

Good luck.
--
Kris Yumul [MS]

This posting is provided "AS IS" with no warranties, and confers no rights

"Matt" <kastro3d (AT) comcast (DOT) net> wrote

Quote:

when i try to run the setup for MSDE i get an error saying:

A strong SA password is required for security reasons.
Please use SAPWD switch to supply the same. Refer to
readme for more details. Setup will now exit.

then in the readme it says this:

When running Desktop
Engine Setup on the Windows NT 4.0 or Windows 2000
operating
system, you can specify a SECURITYMODE=SQL parameter to
have the
installed instance configured to use SQL Server
Authentication
with a null sa password. When run on the Windows 98
operating
system, the Desktop Engine Setup always configures the
installed
instance to use SQL Server Authentication, regardless of
whether
or not SECURITYMODE=SQL is specified.

I'm not very familiar with any of this and don't really
know where to go from now...

#2

A good start will be to familiarize yourself with the installation
information in the ReadMe. It should have the information you need to
install an MSDE instance.

--
Kris Yumul [MS]

This posting is provided "AS IS" with no warranties, and confers no rights

"Matt" <kastro3d (AT) comcast (DOT) net> wrote

Quote:

Kris,
Thanks for your reply, however I'm a beginner in all of
this programming world and have no idea what you just
said :\ How do i specify a strong sa pwd?

-----Original Message-----
As the ReadMe specifies, a strong sapwd is required when
installing an MSDE
instance starting with SP3. Always use SAPWD when
installing and specify a
strong sa pwd.

If you wish to connect using Windows authentication then
you do not need to
specify SECURITYMODE=sql, for non-Win98 if you do not
specify this then it
uses Windows NT authentication. For Win98 the default is
always SQL
authentication (meaning you have to specify the user and
corresponding
password when connecting). More info on this can be
found in
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q319930#6 and
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q285097.

Sample command line to install MSDE, use latest MSDE SP3a
in
http://www.microsoft.com/sql/downloads/2000/sp3.asp,
download the files
necessary to install an MSDE SP3a instance. Please refer
to section 3.7 of
the sp3Readme.htm for installation instructions, this is
important as we
introduced new switches starting in SP3.

setup.exe instancename=test securitymode=sql
sapwd=foo /l*v c:\test.log

This will install an MSDE with instance name TEST using
SQL authentication.
Note to use /l*v switch to create a verbose log, this
will help you verify
if installation was succesful or if it failed at the end
of setup.

sample on how to connect to server in the command line:
net start MSSQL$TEST
osql -Usa -Pfoo -S<machine name>\TEST
1> select @@version
2> go
this should show that you have MSDE version 8.00.761 for
SP3a.
1> exit
net stop MSSQL$TEST

Good luck.
--
Kris Yumul [MS]

This posting is provided "AS IS" with no warranties, and
confers no rights

"Matt" <kastro3d (AT) comcast (DOT) net> wrote in message
news:000001c33ff3$0ab0af20$a501280a (AT) phx (DOT) gbl...
when i try to run the setup for MSDE i get an error
saying:

A strong SA password is required for security reasons.
Please use SAPWD switch to supply the same. Refer to
readme for more details. Setup will now exit.

then in the readme it says this:

When running Desktop
Engine Setup on the Windows NT 4.0 or Windows 2000
operating
system, you can specify a SECURITYMODE=SQL parameter to
have the
installed instance configured to use SQL Server
Authentication
with a null sa password. When run on the Windows 98
operating
system, the Desktop Engine Setup always configures the
installed
instance to use SQL Server Authentication, regardless of
whether
or not SECURITYMODE=SQL is specified.

I'm not very familiar with any of this and don't really
know where to go from now...

.

#3

Matt,

I ran into the same problem today and I also found MSDE's installation
instructions to be somewhat lacking in clarity. After several
missteps, I tried adding the following line to setup.ini:
SAPWD=password (where password whatever pasword you chose). I was
unsure about the requirements for a "strong" password so I just tried
one with 6 letters and 2 numbers. After I adding the above line to
setup.ini, when I ran setup.exe again it proceeded uneventfully. As
far as I know, MSDE 2000 installed correctly.
Good luck,
Steve

"Matt" <kastro3d (AT) comcast (DOT) net> wrote

Quote:

Kris,
Thanks for your reply, however I'm a beginner in all of
this programming world and have no idea what you just
said :\ How do i specify a strong sa pwd?

-----Original Message-----
As the ReadMe specifies, a strong sapwd is required when
installing an MSDE
instance starting with SP3. Always use SAPWD when
installing and specify a
strong sa pwd.

If you wish to connect using Windows authentication then
you do not need to
specify SECURITYMODE=sql, for non-Win98 if you do not
specify this then it
uses Windows NT authentication. For Win98 the default is
always SQL
authentication (meaning you have to specify the user and
corresponding
password when connecting). More info on this can be
found in
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q319930#6 and
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q285097.

Sample command line to install MSDE, use latest MSDE SP3a
in
http://www.microsoft.com/sql/downloads/2000/sp3.asp,
download the files
necessary to install an MSDE SP3a instance. Please refer
to section 3.7 of
the sp3Readme.htm for installation instructions, this is
important as we
introduced new switches starting in SP3.

setup.exe instancename=test securitymode=sql
sapwd=foo /l*v c:\test.log

This will install an MSDE with instance name TEST using
SQL authentication.
Note to use /l*v switch to create a verbose log, this
will help you verify
if installation was succesful or if it failed at the end
of setup.

sample on how to connect to server in the command line:
net start MSSQL$TEST
osql -Usa -Pfoo -S<machine name>\TEST
1> select @@version
2> go
this should show that you have MSDE version 8.00.761 for
SP3a.
1> exit
net stop MSSQL$TEST

Good luck.
--
Kris Yumul [MS]

This posting is provided "AS IS" with no warranties, and
confers no rights

"Matt" <kastro3d (AT) comcast (DOT) net> wrote in message
news:000001c33ff3$0ab0af20$a501280a (AT) phx (DOT) gbl...
when i try to run the setup for MSDE i get an error
saying:

A strong SA password is required for security reasons.
Please use SAPWD switch to supply the same. Refer to
readme for more details. Setup will now exit.

then in the readme it says this:

When running Desktop
Engine Setup on the Windows NT 4.0 or Windows 2000
operating
system, you can specify a SECURITYMODE=SQL parameter to
have the
installed instance configured to use SQL Server
Authentication
with a null sa password. When run on the Windows 98
operating
system, the Desktop Engine Setup always configures the
installed
instance to use SQL Server Authentication, regardless of
whether
or not SECURITYMODE=SQL is specified.

I'm not very familiar with any of this and don't really
know where to go from now...

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: MSDE SAPWD Setup Error

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: MSDE SAPWD Setup Error - 07-01-2003 , 01:48 PM

Re: MSDE SAPWD Setup Error - 07-01-2003 , 03:15 PM

Re: MSDE SAPWD Setup Error - 07-12-2003 , 02:41 PM