Here is a list and a brief description of the new switches.
ALLOWXDBCHAINING=1
Enables cross-database ownership chaining.
For additional information about cross-database chaining, click the following article number to view the article in the Microsoft Knowledge Base:
810474 Cross Database Chaining
BLANKSAPWD=1
Formerly, this was USEDEFAULTSAPWD. This switch overrides the default behavior of the installer. This switch prevents installation with a blank sa password.
If you set BLANKSAPWD=1, you can perform an installation with a blank sa password.
Regardless of whether an instance of Desktop Engine is using Microsoft Windows or Mixed Mode authentication, the Setup cannot continue if a blank password is detected for the sa logon. A warning message appears if a blank password is detected. If you have a blank password for the sa logon, before you continue you must change the password by using the sp_password stored procedure.
You can add an entry to the Property table by using a Windows Installer database editing tool such as Orca.exe to assign specific internal properties used in the SQL Server 2000 SP3 MSDE merge modules to a specific value. For example, to set the instance name, you add an entry to the Property table and assign the SqlInstanceName property a specific value. SQL Server 2000 MSDE merge modules uses the new internal properties that are listed in this table:
| External Property | Internal Property |
|---|---|
| ALLOWXDBCHAINING | SqlAllowXDBChaining |
| BLANKSAPWD | SqlBlankSaPwd |
| DISABLENETWORKPROTOCOLS | SqlDisableNetworkProtocols |
| SAPWD | SqlSaPwd |
| UPGRADEPWD | SqlUpgradePwd |
Note: The internal properties are case-sensitive.
Warning: The use of blank passwords is strongly discouraged.
SAPWD=sa_password
Formerly, SAPASSWORD="sa_password" .
Specifies the sa password. You can use this option for new installations. Unlike other properties, the SAPWD property is hidden and the value is not written to the log file.
If you specify both SAPWD and BLANKSAPWD, SAPWD takes precedence and BLANKSAPWD is ignored.
Important: If you are using an .ini file during set up, avoid storing credentials in the .ini file.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
285103 BUG: BOL Incorrect on SAPASSWORD and USEDEFAULTSAPWD Options for SQL Server 2000 Desktop Engine Installation
UPGRADEUSER=sa
Specifies the logon that will be used when you upgrade Desktop Engine by using SQL Server Authentication. The logon must be a member of the sysadmin fixed server role.
UPGRADEPWD= sa_password
Specifies the password for the logon that is used when you upgrade Desktop Engine by using SQL Server Authentication.
You can specify setup parameters either on a command line or in an .ini file. For more information, see the "Customizing Desktop Engine Setup.exe" topic in SQL Server Books Online.
Important: Avoid storing credentials in an .ini file.