Microsoft® SQL Server ™ 2000 Desktop Engine (MSDE 2000) originally supplied a set of Microsoft Windows® Installer merge modules for independent software vendors (ISVs) to use when installing an instance of MSDE 2000 during their own setup processes. ISVs could use the Windows Installer Setup Development Tools To Merge these Modules Into Their setup program.
The Latest Service Pack for MSDE 2000 Still Includes Merge MODES, But Only To Support Existing Applications That Uses To Install An Instance of Msde 2000 Has The disadvantages:
. The instance of MSDE 2000 can not be patched independently of the application Only a patch module supplied by the application vendor can be applied to the instance; MSDE 2000 service packs directly from Microsoft can not be applied.The application vendor must build an MSDE 2000 patch file for each MSDE 2000 service pack, and then distribute that patch file to all customers. Customers can not simply download and apply the latest Microsoft service pack.Future releases of SQL Server will not include merge modules.
The original MSDE 2000 merge modules were located in the / MSDE / MSM and / MSDE / MSM / 1033 folders on the SQL Server 2000 compact disc. These folders were removed from the SQL Server 2000a compact disc. Do not use the merge modules from the original SQL Server 2000 compact disc, because they install a version of MSDE 2000 that does not address issues related to the Slammer worm. Use only the merge modules from the / MSM and / MSM / 1033 folders created by the latest MSDE 2000 service pack.
Important In the above paragraph, "1033" is the language identifier for English. If you are using an edition of SQL Server localized to another language, the name of this directory will be different. For a list of language identifiers, see syslanguages.Use ..................
Merge modules are used in setup program files built using the Windows Installer SDK. You can download the Windows Installer SDK from Microsoft Developer Network (MSDN®). For more information about the Microsoft Windows Installer Software Development Kit (Windows Installer SDK), see the Msdn Library at this Microsoft Web Site.
The Following Merge Modules Are Required for a Minimal Installation of Desktop Engine.
Merge moduleContentsAtl.msmActive Template Library (ATL) logic, files, and registration informationConnect.msmConnectivityDev_scm.msmService Control Manager developer filesDtc.msmMicrosoft Distributed Transaction Coordinator core filesDts.msmData Transformation Services (DTS) core filesMfc42.msmLogic, files, and registration information needed to install the retail version of the MFCDLL Shared LibraryMsstkprp.msmLogic, files, and registration information needed to install the Microsoft Stock Property PageMsvcirt.msmLogic, files and registration information needed to install the Microsoft Visual C ® Runtime LibraryMsvcrt.msmLogic, files, and registration information needed to install the Microsoft C Runtime LibrarySem.msmSQL Enterprise Manager core filesShared.msmImplements SQL Server local language resource support.Sqlagent.msmSQL Agent core filesSqlsrv.msmSQL Server core filesTools.msmSQL Server tools core filesUpgrade.msmUpgrade files1033 / DTS_res.msmData Transformation Services reso urce files1033 / Sqlagent_res.msmSQL Agent resource files1033 / Sqlbase.msmSQL Server Setup1033 / Sqlsrv_res.msmSQL Server resource files1033 / Tools_res.msmSQL Server Tools resource filesDesktop Engine does not require the merge modules listed in the following table; these modules supply additional functionality You. Can Omit Them To Conserve Space.
Optional merge moduleContentsDmo.msmDistributed Management Objects (DMO) core files1033 / Dmo_res.msmDistributed Management Objects resource filesRepl.msmReplication core files1033 / Repl_msmReplication resource files
No more than 16 named instances of Desktop Engine can be installed on a single computer. Your installer's bootstrapper must check for installed instances, ensuring both that this limit is not exceeded and that new installations have unique names. The Desktop Engine Installation API implements two functions To assistalledinstances and isinstanamevalid. for more information, see installation API for Desktop Engine.customizable Installation Properties
The Setup.exe installation properties that can be changed using switches and .ini file can also be changed in Windows Installer packages by editing the Property table of the main .msi file. To edit the Property table, use a tool such as Orca.exe , WHICH IS Distributed As Part of the Windows Installer SDK. The Properties That Can Be Changed and The Setup.exe Switches to Which They Correspond Are Listed in The Following Table.
External propertyInternal propertyALLOWXDBCHAININGSqlAllowXDBChainingCALLBACKSqlCallbackCOLLATIONSqlCollationDATADIRSqlDataDirDISABLENETWORKPROTOCOLSSqlDisableNetworkProtocolsTARGETDIRSqlProgramDirINSTANCENAMESqlInstanceNameSAPWDSqlSaPwdSECURITYMODESqlSecurityModeUPGRADESqlUpgradeUPGRADEUSERSqlUpgradeUserUPGRADEPWDSqlUpgradePwd
For Information About these Properties, See Customizing DeskTop Engine Setup.exe.
