MSDE MSM- strong SA password error

Products

• Symantec Products

Issue/Introduction

During runtime the following error is received: "A strong SA password is required for security reasons. Please use the SAPWD switch to supply the same. Refer to readme for setup details."

Cause

MSDE merge module doesn't allow blank SA passwords by default.

Resolution

Microsoft is recommending bootstrapping the MSDE .EXE to an installation rather than using the merge modules to install MSDE with an installation.  

Wise makes this easy for you by adding the MSDE to the prerequisites page in Installation expert. Follow the steps below to add MSDE runtime to an .EXE wrapper:

1. In Installation Expert, select Build Options page and select Single File .EXE from the .EXE options drop down list. You may receive an error message indicating to change the Media type if you have external uncompressed files or external cabs set in the media options.  A Single file .EXE (only valid for files inside .MSI) can only be used when the Media type of internal compressed files.  If you have the Media page set to external uncompressed or external cabs, you need to use the .EXE that launches external .MSI option.
2. Select Prerequisites page from Installation Expert.
3. Click Add then select Runtimes.  

If the MSDE 2000 Release A runtimes is not on your computer:

1.  Select Help > Download Redistributables.  Mark the Other Vendors' Web Site option and download the MSDE 2000 runtime.
2.  Double-click the downloaded MSDE2000A.EXE to extract the MSDE installation files to your computer.
3. Specify the path to the MSDE files when prompted when incluyding the runtime

The MSDE runtime will appear in the list. Selecting this will include the runtime in an .EXE wrapper that is placed on the computer prior to executing the .MSI. The MSDE runtime should be on the computer to add it here, but can be downloaded by following the instructions on the MSDE Release A Runtime dialog during the process of including the runtime.

 If you have a blank password, this will cause this error to appear:

If you would like to use a blank SA password, you can set BLANKSAPWD=1 in the property table of the merge module. Included with this article is a link to Microsoft's article on the switches that can be used for the MSDE setup.

This issue is also applicable to SQL Server merge modules.

Related Links
http://support.microsoft.com/default.aspx?scid=kb;en-us;810826

Applies To
MSDE merge modules
SQL Server merge modules