Friday, March 30, 2012

installing msde 2000a

I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following......

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

Does any one know what I need to do to fix this?

-Thanks

Try reading the 'Readme' file. There you will see the instructions to include the /SAPWD switch and also include a password during installation.

|||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:

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

You have 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.

No comments:

Post a Comment