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

[SHC]

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.


"SHC" <***@discussions.microsoft.com> wrote in message news:91E7DEE8-99EF-4611-BC95-***@microsoft.com...
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

[SHC]

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

Post by 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
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.
a.. To install a default instance configured to use Windows
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
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.
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQLWhere AStrongSAPwd is a strong
password to be assigned to the sa login.
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

[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.


"SHC" <***@discussions.microsoft.com> wrote in message news:2D88D8D8-C16E-40AB-AE79-***@microsoft.com...
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

Post by 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
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.
a.. To install a default instance configured to use Windows
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
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.
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQLWhere AStrongSAPwd is a strong
password to be assigned to the sa login.
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

[Marcello Miorelli]

I have got a good way to do it.
I go to the folder where the setep.exe is, in my case 'c:\SQL2KSP4' and I
create a .BAT file.
Inside this bat file I write the command.

In my case I have an instance called KRISHNA.


The command is:

setup INSTANCENAME="KRISHNA$" SAPWD="Pa55w0rd"

and it's worked fine.

Another thing I do before I even start editing this BAT file is STOPPING ALL
the services related to the SQL Server.
In my case also, we use windows authentication.

Hope this helps. Thanks David for your answers.
Marcello Miorelli

url:http://www.ureader.com/msg/10593282.aspx

[gary sativa]

Brilliant .bat fix. THANKS!!!

url:http://www.ureader.com/msg/10593282.aspx

[Romman]

a strong password is required for security reason please use SAPWD switch to
supply the same

url:http://www.ureader.com/msg/10593282.aspx

[Romman]

a strong password is required for security reason please use SAPWD switch to
supply the same

url:http://www.ureader.com/msg/10593282.aspx