english francais

Installing MSDE

I am having problems installing the MSDE SQL server software from Microsoft. For example, I am receiving an error about the SA password.

Article Details

For Microforge.net Enterprise Server Desktop Edition 1.2.9 or later, the MSDE setup files are included in the installation package.  To install MSDE with some default settings (blank password, no instance name, etc.) you may run the setup.bat script in the Program Files \ Microforge.net \ MSDE folder.  Otherwise, you may change the install settings by editing the setup.bat and setup.ini files in the same directory.  For more information, please follow the Microsoft Knowledge Base link at the bottom of the page.

The error message that you are getting when trying to install MSDE is basically just saying that the password you provided to the MSDE setup program is not good enough. You'd normally get that message if you didn't provide any password to the setup routine, so there are two basic ways to get rid of the error message (and proceed with the setup). The first is to provide a password and the second is to supply an additional parameter to the setup routine overriding this strong password check, so that you can install MSDE with no password at all.

In either case, you basically need to supply some additional parameters to the msde setup program (you can not just double click on it, but must run "setup" from the command line with additional parameters, UNLESS you specify the options in a setup.ini file in the same directory as the setup.exe ). You can provide a password to the msde setup program by using the sapwd parameter... so if you wanted to use the password billyboy you could type the following from the command line:

  setup SAPWD="billyboy"

For more information on MSDE Setup.exe Parameters, please see Microsoft Knowledge Base Article -  INF: New Switches in MSDE Service Pack 3 Setup