BUG: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2 Installed

Article translations Article translations
Article ID: 299351
This article was previously published under Q299351
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 353405 (SHILOH_BUGS)
Expand all | Collapse all

On This Page

Symptoms

The installation of SQL Server 2000 Desktop Engine RTM (also known as MSDE 2000) fails on systems if any edition of SQL Server 2000 with Service Pack 1 or Service Pack 2 is already installed.

The MSDE setup log includes the following error messages:
  • LoadLibrary failed for [path]\Binn\SEMNT.DLL. GetLastError() returned: 126
    -and-
    Microsoft SQL Server Desktop Engine -- Installation operation failed.
This problem only happens if you are installing MSDE 2000 RTM (build 8.00.194.01). It does not happen if you are performing a SQL Server 2000 Desktop Engine Service Pack Full Install.

Cause

On a system that has SQL Server 2000 Service Pack 1 or Service Pack 2 installed, the installation program for MSDE 2000 RTM will not copy certain essential files to the necessary directories because newer versions of these files already exist, even though the files are in a different location.

RESOLUTION

To resolve this problem, obtain a full refresh of the MSDE files at the latest service pack level and perform a SQL Server 2000 Desktop Engine Service Pack X Full Install. You can obtain the same, either through an MSDN Subscription or you can call Microsoft Product Support Services (PSS).

Workaround

To work around this behavior, follow these steps:
  1. Before you run the MSDE installation, rename the following files as indicated:

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Semnt.rll to Semnt.rld

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqlsvc.rll to Sqlsvc.rld

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Semnt.dll to Semnt.dld

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Sqlsvc.dll to Sqlsvc.dld

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Sqlresld.dll to Sqlresld.dld
  2. Execute the MSDE installation.
  3. Rename the following files back to their original names as indicated:

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Semnt.rld to Semnt.rll

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqlsvc.rld to Sqlsvc.rll

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Semnt.dld to Semnt.dll

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Sqlsvc.dld to Sqlsvc.dll

    • \Program Files\Microsoft SQL Server\80\Tools\Binn\Sqlresld.dld to Sqlresld.dll

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 1.

More information

  • Because this problem does not occur with the installation of a full refresh of MSDE at the latest service pack level, please use the same and install MSDE 2000. As opposed to installing MSDE RTM and then upgrading to the latest service pack, this method of installation helps you to simultanesouly install MSDE and also to keep it updated at the latest service pack level.For additional information about how to obtain the full refresh version of MSDE, click the article number below to view the article in the Microsoft Knowledge Base:
    315721 INF: Can Only Apply SQL Server 2000 Desktop Engine (MSDE) Service Pack 2 Download on the Internet to Instances Installed from Sqlrun01.msi
  • You can specify that a verbose MSDE setup log file be 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]

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
227091 Command-Line Switches for the Windows Installer Tool
If Microsoft Application Center is involved, click the article number below to view the article in the Microsoft Knowledge Base:
296628 PRB: Application Center 2000 Install Fails With SQL 2000 SP1

Properties

Article ID: 299351 - Last Review: October 26, 2013 - Revision: 2.0
Keywords: 
kbnosurvey kbarchive kbbug kbDSupport KB299351

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com