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

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.

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).

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

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  (http://support.microsoft.com/kb/315721/EN-US/ ) 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: If Microsoft Application Center is involved, click the article number below to view the article in the Microsoft Knowledge Base: