This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 353405 (SHILOH_BUGS)
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
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.
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.
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).
To work around this behavior, follow these steps:
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
Execute the MSDE installation.
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
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.
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:
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