PRB: Cannot Specify Instance Name Using SQL Server 2000 Merge Modules

Article translations Article translations
Article ID: 281983
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

Symptoms

When using the SQL Server 2000 Desktop Engine merge modules as an integrated part of a custom setup, you may not be able to customize the Microsoft Data Engine (MSDE) installation using the same command-line parameters as with the SQL Server 2000 Desktop Engine install package.

Cause

External properties that are exposed by way of the command line in the SQL Server 2000 Desktop Engine install package are not exposed in the SQL Server 2000 MSDE merge modules. This is in order to allow customers using the merge modules to control the way these properties are used. For example, you may not want to allow the SQL instance name to be changed from the command line; rather, you may wish to author a specific instance name in the Property table of your custom install package.

Resolution

The setup author could add an entry to the Property table by using a Windows Installer database editing tool such as Orca.exe to assign the specific internal properties used in the SQL Server 2000 MSDE merge modules to a specific value. For example, to set the instance name to be used, you would add an entry to the Property table and assign the SqlInstanceName property a specific value.

The following internal properties are used by the SQL Server 2000 MSDE merge modules and can be set in this manner. The corresponding external properties are listed for reference; however, they are available only in the SQL Server 2000 Desktop Engine install package, not the SQL Server 2000 MSDE merge modules.

Collapse this tableExpand this table
External PropertyInternal Property
CALLBACKSqlCallback
COLLATIONSqlCollation
DATADIRSqlDataDir
TARGETDIRSqlProgramDir
INSTANCENAMESqlInstanceName
SECURITYMODESqlSecurityMode
UPGRADESqlUpgrade
UPGRADEUSERSqlUpgradeUser

Some of the above properties must be specific values. The value of SECURITYMODE or SqlSecurityMode should be SQL in order to allow SQL Server authentication. For upgrading, UPGRADE or SqlUpgrade should be 1, and UPGRADEUSER or SqlUpgradeUser should be SA.

Status

This behavior is by design.

References

255905 HOWTO: Use Orca to Edit Windows Installer Files

Properties

Article ID: 281983 - Last Review: June 19, 2014 - Revision: 3.0
Keywords: 
kbnosurvey kbarchive kbproductlink kbprb KB281983

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com