Microsoft KB Archive/303680

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

Article ID: 303680

Article Last Modified on 2/25/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)

-



This article was previously published under Q303680



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 &quot;NULL&quot;. 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 &quot;Cause&quot; 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

