SQL Server 2000 MSDE Service Pack 1 Setup on Windows 98 computer fails with error message

Article translations Article translations
Article ID: 303680
This article was previously published under Q303680
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

Symptoms

When you try to install Microsoft SQL Server 2000 Desktop Engine (MSDE) Service Pack 1 onto a Microsoft Windows 98-based computer, the setup may fail with the following error message:
Unable to run script files.

Cause

During the SQL Server 2000 MSDE Service Pack 1 installation on the Windows 98-based computer, the setup tries to connect to the SQL Server server to run the following three scripts:
  • Sp1_serv_uni.sql
  • 80sp1-tools.sql
  • Sp1_repl.sql
The SQL Server 2000 MSDE Service Pack 1 installation attempts to log on by using either Microsoft Windows NT authentication or SQL Server authentication. SQL Server 2000 MSDE on a Windows 98-based computer only has SQL authentication. The SQL Server 2000 MSDE Service Pack 1 installation fails if you do not specify a SQL authentication login to run the upgrade. The installation fails because it attempts to log on as user "NULL". The following error message is recorded in the Sp1_serv_uni.out file, which indicates that the problem occurred while the installation was trying to run the Sp1_serv_uni.sql script:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Workaround

To avoid the problem described in the "Cause" section of this article, specify a SQL authentication login to run the SQL Server 2000 MSDE Service Pack 1 installation. You must also add the Upgradeuser property to the Setup.ini file that is used by the SQL Server 2000 Desktop Engine installation.
  1. Download the SQL Server 2000 Desktop Engine Service Pack 1 file (Sql2kdesksp1.exe).
  2. Extract the contents of Sql2kdesksp1.exe.
  3. Edit the Setup.ini file by using Notepad and add the following text: UPGRADEUSER=sa
Note The sa password must be set to NULL before you apply SQL Server 2000 MSDE Service Pack 1. You can change the sa password after the upgrade completes.

Note We recommend that you install Microsoft SQL Server 2000 MSDE Service Pack 4 (SP4). For more information about SQL Server 2000 MSDE SP4, visit the following Microsoft Web site:
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desksp4.htm#_acquiring_desktop_engine_sp4

References

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
299351 BUG: MSDE installation fails on systems that have SQL Server 2000 Service Pack 1 or 2 installed
281983 Cannot specify instance name using SQL Server 2000 merge modules

Properties

Article ID: 303680 - Last Review: November 2, 2013 - Revision: 3.0
Keywords: 
kbnosurvey kbarchive kbprb KB303680

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