 |
 |
|
|
|
|
MSSQL Developer Edition (MSDE) Installation Quick Start Tutorial
| This is based on installing MSDE SP3 onto Windows 2000. When you simply try to run the MSDE-SP3 installer you will unfortunately be greeted with an error message telling you that you are required to use a strong SA (System Administrator) password. The exact text of the error message is this: Microsoft SQL Server Desktop Engine: 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. This is a recent change to increase the security of MSSQL in response to some damaging internet worms which had propagated wildly through thousands of MSSQL installations which had not been assigned an sa password. This requirement is addressed very simply by passing 2 specific attributes to the Setup.exe for MSDE. If you were doing the installation from the command line it would be the same. The simpler method is to pass these attributes or options to Setup.exe by creating and modifying a shortcut. Create a shortcut to Setup.exe In the target field, add the following to the end of the target line which should be showing the path to Setup.exe in your installation folder. Add this immediately after Setup.exe: SAPWD=yourpassword SECURITYMODE=SQL Of course you will replace yourpassword with a good password of your choice. Write it down in a secure location and don't lose this. In connection strings or database utilities you will connect to MSDE using the username of sa and the yourpassword of your choice. |
 |
