SQL Server - Error installing MSDE - SAPWD switch?

Asked By John Rubin on 21-May-03 11:54 AM
Not a great beginning to transferring my Access database to SQL Server. When I try to install the version of MSDE I just downloaded from Microsoft, I immediately get the following error message:


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.


I tried the readme file and can't understand what they're saying to do. Any ideas?

Thanks!

THey want you to create a password - Asked By Dexter Dotnetsky on 21-May-03 03:52 PM

for the "sa" *System admin" adminstrative account.

Lot's of people leave it blank, no can do. Need to supply a good strong password.

Look up the SAPWD switch details in the documentation on how to .

MSDE - SAPWD switch - Asked By Arne Exton on 20-Oct-03 03:55 AM

Put the line

SAPWD=XXXXX

in the setup.ini file where XXXXX is the pwd of your choice. It will work.

Good luck!

Arne Exton

Oi - Asked By Douglas Abreu on 04-Oct-04 12:46 PM

Preciso de server
Oi - Asked By Douglas Abreu on 04-Oct-04 12:48 PM
SAPWD
SAPWD - Asked By Tina Tina on 08-Nov-04 03:55 PM
Hi, 

Open the setup.ini and  add the SAPWD=sa_password to the [options] section:

[Options]
SAPWD=sa_password

It works for me.

Good luck :)
Hi Rubin here is the answer for ur question htt - Asked By Prasanna K Kuttuva on 26-Apr-05 10:12 AM
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp



Open a command prompt window.


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.

Execute one of the following commands: 
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.
Nurzhan replied to John Rubin on 14-Mar-11 08:28 PM
problems   sql server