BUG: Installation of SQL Server 2000 Desktop Engine Fails on Computers That Already Have SQL Server 7.0 Tools Installed (275307)

SYMPTOMS

If you install an instance of Microsoft SQL Server 2000 Desktop Engine on a computer that already has the SQL Server 7.0 client tools installed, the installation fails during the SkuIt custom action and the following error message appears in the setup log file:

Loading extended custom action library sqlcax.dll
Starting custom action SkuIt
An internal error occurred during install (failed to load package id).
Contact Microsoft Technical Support.
Action ended 15:35:19: InstallFinalize. Return value 3.

CAUSE

This problem occurs when the SQL Server 2000 Desktop Engine Setup detects the Sqlboot.dll file from the SQL Server 7.0 installation. The Sqlboot.dll file in use is from the MSSQL7\Binn directory.

WORKAROUND

To work around this behavior, follow these steps:

Rename the Sqlboot.dll file in the C:\MSSQL7\Binn folder.
Install the MSDE named instance.
Rename the Sqlboot.dll file mentioned in step 1 back to Sqlboot.dll.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

This problem was corrected in a later release of Microsoft SQL Server 2000, Desktop Engine Edition, which is available as a "Refresh CD" created to fix this specific problem. The Refresh CD is a full copy of Microsoft SQL Server 2000, Desktop Engine Edition.

Contact Microsoft Product Support Services to obtain the Refresh CD. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, refer to the Microsoft Web site at:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

Additionally, the later release of Microsoft SQL Server 2000, Desktop Engine Edition (MSDE 2000), is included in the following products when they ship:

Microsoft Visual Studio.NET
Microsoft Office XP
Microsoft Application Center

MORE INFORMATION

You can specify that you want a verbose MSDE setup log file created and include the name and location of the MSDE setup file by running the setup program with the following command-line switch:

/L*v [filename]

The following text is from SQL Server 2000 Books Online:

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.

REFERENCES

SQL Server 2000 Books Online