Microsoft KB Archive/281184

{|
 * width="100%"|

FIX: SQL Server 2000 Desktop Engine Merge Modules Dependencies Are Incorrect

 * }

Q281184

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)
 * Microsoft SQL Server 2000 Desktop Engine

-

BUG #: 351238 (SHILOH_BUGS)

SYMPTOMS
When you use the Microsoft SQL Server 2000 Desktop Engine merge modules as an integrated part of a Windows Installer based custom setup, you may see build errors from setup authoring tools about unfulfilled merge module dependencies or about being unable to merge rows from the Directory table.

Here are error messages that occur with InstallShield 2.0:


 * Error -4072: Merge module DMO1033.6496AA57_4ABB_4A5B_A0A9_E712ECFA8092:1033 not found.


 * Error -4072: Merge module DTS1033.9240E1C0_49D2_40A2_93CE_E62CD8B48DDC:1033 not found.


 * Error -4072: Merge module REPL1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128:1033 not found.


 * Error -4072: Merge module SEM1033.EF490CFB_7BC2_4102_8395_426CE5870B18:1033 not found.


 * Error -4072: Merge module SQLAGENT1033.BF65A835_E76E_4CA5_8B97_E8FD33E7C475:1033 not found.


 * Error -4072: Merge module SQLSVR1033.88C26F26_166C_4CD7_8175_38297C2276D7:1033 not found.


 * Error -4072: Merge module TOOLS1033.ACD7EC22_4989_4067_B267_6DB5716695BC:1033 not found.


 * Error -4072: Error retrieving the dependencies for c:\msm\DMO.MSM


 * Error -4072: Error retrieving the dependencies for c:\msm\DTS.MSM


 * Error -4072: Error retrieving the dependencies for c:\msm\REPL.MSM


 * Error -4072: Error retrieving the dependencies for c:\msm\SEM.MSM


 * Error -4072: Error retrieving the dependencies for c:\msm\SQLAGENT.MSM


 * Error -4072: Error retrieving the dependencies for c:\msm\SQLSVR.MSM


 * Error -4072: Error retrieving the dependencies for c:\msm\TOOLS.MSM

The third-party products discussed in this article are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

CAUSE
Some of the SQL Server 2000 merge modules are language-neutral and require a language specific module to function properly. The ModuleDependency table of the language-neutral module requires a module with LangID of 1033, but the ModuleSignature of the required module has a LangID of 0, which results in the unfulfilled dependency.

This problem specifically affects the following merge modules:


 * Sqlagent.msm
 * Sem.msm
 * Sqlsvr.msm
 * Tools.msm
 * Dts.msm
 * Repl.msm
 * Dmo.msm

The build errors regarding merging conflicts are a result of the the merge modules Connect.msm, Sqlbase.msm, and Sqlsvr.msm having entries in the Directory table that do not follow the merge module naming convention of appending the Module ID to the primary key.

RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, please see the following article in the Microsoft Knowledge Base:

"Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack"

Hotfix
NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.

The English version of this fix should have the following file attributes or later:

  Date         Time         Size              File name ---

12/05/2000  3:03:06 AM   1,263,104 bytes   Sqlbase.msm

NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

MORE INFORMATION
To use this fix, use all of the provided .msm files in the hotfix to replace the ones that are in the current setup. You only need to replace the ones that are provided in this hotfix, you do not need to replace the existing ones that are not in this fix.

Additional query words:

Keywords : kbAppSetup kbDeployment _IK kbSQLServ2000bug kbSQLServ2000sp1fix

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ2000Search kbSQLServ2000