MSDE 2000 Release A: How to Use SAPWD switch to Suuply the SA pass

[Guest]

Hi all,
I have Windows XP Pro PC that is linked on Microsoft NT 4 LAN System. I
downloaded all the installation files of MSDE 2000 Release A to my
C:\MSDERelA forlder. I clicked on the setup.exe
(Microsoft SQL Server Setup) in my C:\MSDERelA folder. First, I saw the
message "Please wait while Windows configures Microsoft SQL Server Desktop
Engine", and then "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 exist." I am completely lost in this matter of installing
MSDE 2000 Release A. Please help and tell me how I can use SAPWD switch to
supply the strong SA password during the setup.
Thanks again,



SHC

 

[David Lloyd]

The following is from the "sp3readme.htm" file located in the same folder as
the setup.exe file.

To install a new instance of Desktop Engine

1.. Open a command prompt window.


2.. From the command prompt, use the cd command to navigate to the folder
containing the MSDE 2000 SP3a setup utility:
cd c:\MSDESP3aFolder\MSDE

where c:\MSDESP3aFolder is either the path to the folder into which you
extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the
SQL Server 2000 SP3a CD.

3.. Execute one of the following commands:
a.. To install a default instance configured to use Windows
Authentication Mode, execute:
setup SAPWD="AStrongSAPwd"Where AStrongSAPwd is a strong password to be
assigned to the sa login.

b.. To install a named instance configured to use Windows Authentication
Mode, execute:
setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"Where AStrongSAPwd is
a strong password to be assigned to the sa login and InstanceName is the
name to be assigned to the instance.

c.. To install a default instance configured to use Mixed Mode, execute:
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQLWhere AStrongSAPwd is a strong
password to be assigned to the sa login.

d.. To install a named instance configured to use Mixed Mode, execute:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"Where
AStrongSAPwd is a strong password to be assigned to the sa login and
InstanceName is the name to be assigned to the instance.

Here are some additional references

http://support.microsoft.com/default.aspx?scid=kb;en-us;810826
http://support.microsoft.com/kb/322336/EN-US/

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi all,
I have Windows XP Pro PC that is linked on Microsoft NT 4 LAN System. I
downloaded all the installation files of MSDE 2000 Release A to my
C:\MSDERelA forlder. I clicked on the setup.exe
(Microsoft SQL Server Setup) in my C:\MSDERelA folder. First, I saw the
message "Please wait while Windows configures Microsoft SQL Server Desktop
Engine", and then "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 exist." I am completely lost in this matter of installing
MSDE 2000 Release A. Please help and tell me how I can use SAPWD switch to
supply the strong SA password during the setup.
Thanks again,



SHC

 

[Guest]

Hi Dave, Thanks for your response.

I did what you instructed and I got the same message from the execution of
MSDESP3a. I still can not install MSDE 2000 or MSDE 2000 Release A. I wonder
how people actually install the MSDE 2000 or MSDE 2000 Release A in Windows
XP Pro - Microsoft NT 4 LAN System. Please help and tell me what is missing
in the installation procedures the MSDE 2000 SP3a or MSDE 2000 Release A does
not include in its README file.

Thanks,
SHC

 

[David Lloyd]

It is hard to know all the details of your specific installation. When
specifying the sa password, are you using a "strong" password?

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi Dave, Thanks for your response.

I did what you instructed and I got the same message from the execution of
MSDESP3a. I still can not install MSDE 2000 or MSDE 2000 Release A. I
wonder
how people actually install the MSDE 2000 or MSDE 2000 Release A in Windows
XP Pro - Microsoft NT 4 LAN System. Please help and tell me what is missing
in the installation procedures the MSDE 2000 SP3a or MSDE 2000 Release A
does
not include in its README file.

Thanks,
SHC