Merging the Desktop Engine into Windows Installer

The Microsoft® SQL Server™ 2000 Desktop Engine is available as a set of Windows Installer merge modules, which can be used by independent software vendors (ISVs) to install an instance of the SQL Server 2000 Desktop Engine during their own setup process. These merge modules can be merged into the ISV setup program using available Windows Installer setup development tools. The SQL Server 2000 Desktop Engine merge modules are located in the /Sqlmsde/Msm folder on the SQL Server 2000 compact disc. For more information about Windows Installer, see the MSDN Library at Microsoft Web site.

You can reduce the disk footprint of your application by customizing the SQL Server 2000 Desktop Engine Setup so that it does not install SQL Server 2000 components that are not used by your application. You can do this by removing the merge modules for the component from your application Windows Installer setup. You must include all of the SQL Server 2000 Desktop Engine merge modules in your application setup, except for the modules listed here.

Optional SQL Server 2000 Component	Merge Modules for that Component
SQL Server database replication components	Repl*.msm
SQL Distributed Management Objects (SQL-DMO)	Dmo*.msm

You can remove the replication merge modules, the SQL-DMO merge modules, or both.

You can add entries in the [Options] section of your Windows Installer .ini file that customizes the installation of the instance of the Desktop Engine. These are the settings and their descriptions.

TARGETDIR="executable_folder_path"

Specifies the folder where the Desktop Engine executable files are installed. The default for executable_folder_path is C:\Program Files\Microsoft SQL Server.

DATADIR="data_folder_path"

Specifies the folder where the Desktop Engine system databases are built. The default is the same folder used for the Desktop Engine executable files.

INSTANCENAME="instance_name"

Specifies the name for the instance. If no instance name is specified, the instance is installed as a default instance.

COLLATION="collation_name"

Specifies the SQL Server collation that will be used as the default collation for this instance of the Desktop Engine. For information about a list of collation names, see Windows Collation Name and SQL Collation Name.

CALLBACK=Dllname!CallbackFunctionName

Specifies the name of the DLL containing the Desktop Engine Windows Installer callback function, and the name of the callback function. For more information, see Desktop Engine Windows Installer Callback Functions.

USEDEFAULTSAPWD

Specifies that setup assign the default password (NULL) to the sa login. You must specify either USEDEFAULTSAPWD or SAPASSWORD, but not both.

SAPASSWORD="sa_password"

Specifies that setup assign a password to the sa login. You must specify either USEDEFAULTSAPWD or SAPASSWORD, but not both.

Note  Settings that contain spaces should be enclosed with quotation marks in the .ini file entries. For example:

TARGETDIR="C:\Program Files\Microsoft SQL Server\Instance1"

For more information about what values to specify for the .ini file settings, see SQL Server 2000 Desktop Engine Setup.