The TEMP or the TMP environment variable setting may cause an unsuccessful installation of SQL Server 2000 64-bit (889541)

SYMPTOMS

When you try to install Microsoft SQL Server 2000 64-bit, the installation may be unsuccessful when the TEMP or the TMP environment variable has a space character in the folder name.

When the installation is unsuccessful, the computer may stop responding, and messages that are similar to the following will be logged in the following log files:

SQLRun01.log

=== Logging stopped: (date) (time) === 
MSI (c) (18:F4): Note: 1: 1708 
MSI (c) (18:F4): Product: Microsoft SQL Server Enterprise Edition (64-bit) -- Installation failed.
MSI (c) (18:F4): Grabbed execution mutex.
MSI (c) (18:F4): Cleaning up uninstalled install packages, if any exist
MSI (c) (18:F4): MainEngineThread is returning 1602

SQLRun0.log

=== Logging stopped: (date) (time)===
MSI (c) (40:D8): Note: 1: 1708 
MSI (c) (40:D8): Product: Microsoft SQL Server Enterprise Edition (64-bit) -- Installation failed.
MSI (c) (40:D8): Grabbed execution mutex.
MSI (c) (40:D8): Cleaning up uninstalled install packages, if any exist
MSI (c) (40:D8): MainEngineThread is returning 1603
=== Verbose logging stopped: (date) (time)===

SQLStp1.log (at the end of the log file)

<Func Name='CServiceNT::Close'>
<EndFunc Name='CServiceNT::Close' Return='T' GetLastError='997'>
<Func Name='CService::~CService'>
<EndFunc Name='CThreadPool::ClearThreadPool' Return='0' GetLastError='183'>
<EndFunc Name='RunRemoteProcesses' Return='1605' GetLastError='183'>

WORKAROUND

To work around this problem, change the value for the TEMP or the TMP environment variable for the system account and for the user account that will be used to install SQL Server 2000 64-bit. If you want to restore the values for these variables after the installation, make a note of the values before you change them. To change the environment variable values, follow these steps:

Create a folder at the root of the local drive and name it TEMP.
Click Start, right-click My Computer, and then click Properties.
In the System Properties dialog box, click the Advanced tab.
Click Environment Variables.
Repeat the following steps for both the TEMP and the TMP User variables:
1. In the User variables list, select the TEMP variable, and then click Edit.
2. In the Variable value box, type %drive%\TEMP, and then click OK.
  
  Note %drive% is the local drive where you created the folder in step 1.
3. Repeat steps a and b for the TMP variable, if it exists.
Repeat the following steps for both the TEMP and the TMP System variables:
1. In the System variables list, select the TEMP variable, and then click Edit.
2. In the Variable value box, type %drive%\TEMP, and then click OK.
  
  Note %drive% is the local drive where you created the folder in step 1.
3. Repeat steps a and b for the TMP variable, if it exists.
Click OK two times to close the System Properties dialog box.
Click Start, click Run, type cmd in the Open box, and then click OK.
At the command prompt, type the following command to verify that the TEMP and the TMP environment values are equal to %drive%\TEMP:

set t

Note %drive% is the local drive where you created the folder in step 1.
At the command prompt, in the root of your SQL Server 2000 installation folder, type the following command:
setup.exe /l*v C:\TEMP\setupfail.txt

Note If you want to restore the values for the TEMP and the TMP environment variables after the installation, follow step 2 through step 7 to restore the original values.