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


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
This article was previously published under Q299351
BUG #: 353405 (SHILOH_BUGS)

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

Modification Type:MajorLast Reviewed:11/4/2002
Keywords:kbBug kbDSupport KB299351 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.