Microsoft KB Archive/274224

= FIX: Using SQL Server 2000 Merge Modules May Result in Confusing Message =

Article ID: 274224

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q274224



BUG#: 236087 (SHILOH_BUG)



SYMPTOMS
When you run a setup program that uses the SQL Server 2000 Microsoft Data Engine (MSDE) merge modules, you may receive the following error message:

Setup requires Internet Explorer version 5.0.2314.0 or above.

If the SQL Server 2000 MSDE merge modules were used in a custom setup program, you may also receive the following error message when attempting to install SQL Server 2000 MSDE on Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows Millennium Edition (Me):

An internal error occurred during install (failed to load package id). Contact Microsoft Technical Support.



CAUSE
The first error message is a bug caused by certain tools that use the merge modules to create the setup program. This has been resolved in the Sqlbase.msm merge module so that the proper detection is done when searching for Internet Explorer 5.0. The second error is also a bug in the Sqlbase.msm file. Both errors are now resolved.



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

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

IMPORTANT: Some customers have reported that a new setup that is built using this fix may fail to run on Microsoft Windows NT 4.0. After testing done at Microsoft, it has been found that the ProductLanguage property specified in the Property table in the .msi file built by certain setup creation tools may be set incorrectly. ProductLanguage should be set to 1033 instead of 0. You can use a tool such as Orca.exe (which ships in the Windows Installer SDK) to change the ProductLanguage property in the Property table in the .msi file from 0 to 1033. For additional information on Orca, click the article number below to view the article in the Microsoft Knowledge Base:

255905 HOWTO: Use the Orca Database Editor to Edit Windows Installer Files



WORKAROUND
If you have already released your setup program, you can pass the APPS_TEST property on the setup command line to resolve the Internet Explorer 5.0 error message. For example, you could use the following in a batch file or at a command line prompt: setup.exe APPS_TEST=1 You can also use a table editor like Orca.exe to add the APPS_TEST property to the property table for the .msi installation package created by the setup tools. If you choose to do this, you can assign the APPS_TEST property any value you wish. However, this only resolves the Internet Explorer 5.0 error message.

If you need the installation to work properly on Windows 95, Windows 98, and Windows Me, follow the instructions in the &quot;Resolution&quot; section to resolve both the Internet Explorer 5.0 error message and the installation on non-Windows NT based computers. Note that the steps listed in the &quot;Resolution&quot; section require the setup to be rebuilt.

Another option is to not use the merge modules to deploy SQL Server 2000 MSDE and instead use the Microsoft-supplied setup program for SQL Server 2000 MSDE. For more information on this option, see the Distsql.chm SQL Server 2000 MSDE redistribution Help file on the SQL Server 2000 CD-ROM.



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

Keywords: kbqfe kbsqlserv2000sp1fix kbprb KB274224

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.