PRB: SQL Server 7.0 Service Pack 2 Installation Fails with -115 Error (282976)

SYMPTOMS

When you try to install Microsoft SQL Server 7.0 Service Pack 2 (SP2), the installation fails while it is trying to copy the SQL Server script files. You may get the following error message:

SP2 setup an error occurred during the move data process: -115

The following information is located in the Sqlsp.log file located in the Windows\Temp directory of the computer on which it was run:

09:09:27 Setup is installing Microsoft Management Console (MMC) ...
09:09:27 C:\MSSQL7\X86\Other\instmmc.exe  /Q
09:09:48 Process Exit Code: (0) 
09:09:48 End ProcessBeforeDataMove
09:09:48 Begin MoveFileData
09:29:07 Begin CleanUpInstall
09:29:07 Installation Failed.

CAUSE

Two possible causes have been identified for this problem:

The directories into which files are copied do not have Change or Modify NTFS permissions for the account under which the setup is run. Or, the directories have a Read-Only attribute set. The directories to check are:
- BINN
- INSTALL
- BOOKS
- DATA
The SP2 files were extracted into the SQL Server installation directory. When you extract the SP2 installation files by executing Sql70sp2i.exe (for the Intel platform) the following directories are created.
- HTML
- INSTALL
- X86
The SQL Server installation folder already contains an INSTALL directory. Extracting the service pack files into the SQL Server installation directory does not create a second INSTALL directory. Later when the service pack setup moves files from the source to the destination directories, a failure occurs because the source directory INSTALL was not created.

WORKAROUND

To work around this problem, use these steps:

Make sure that the appropriate SQL Server directories have at least modify/change permissions for the Microsoft Windows NT account that runs the installation.
Make sure that you expand the Service Pack 2 files into a directory other than the SQL Server installation directory when you run Sql70sp2i.exe or Sql70sp2a.exe

MORE INFORMATION

Here is the relevant section from the SQL Server 7.0 Service Pack 2 Readme.txt file:

254555 INF: Readme.txt for SQL Server 7.0 Service Pack 2

2.2 Extracting Database Components Service Pack 2

To extract the Database Components, copy the self-extracting file into a folder on the computer running SQL Server or MSDE. From that folder, execute the file. The program will prompt for the name of the directory in which to place the service pack files. For example, if you are running SQL Server or MSDE on an Intel-based computer and have created a directory named C:\70sp2, copy the file Sql70sp2i.exe to your computer, execute it, and provide the name of the C:\70sp2 directory when prompted.