You are currently offline, waiting for your internet to reconnect

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



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 existMSI (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 existMSI (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'>
CAUSE
This problem occurs when the TEMP or the TMP environment variable has a space character in the folder name. For example, the following TEMP environment value may cause this problem:
D:\Documents and Settings\UserName\Local Settings\Temp
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:
  1. Create a folder at the root of the local drive and name it TEMP.
  2. Click Start, right-click My Computer, and then click Properties.
  3. In the System Properties dialog box, click the Advanced tab.
  4. Click Environment Variables.
  5. 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.
  6. 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.
  7. Click OK two times to close the System Properties dialog box.
  8. Click Start, click Run, type cmd in the Open box, and then click OK.
  9. 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.
  10. 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.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
SQLSERVER IA64 AMD64
Properties

Article ID: 889541 - Last Review: 12/17/2004 16:49:35 - Revision: 1.2

  • Microsoft SQL Server 2000 64-bit Edition
  • kbtshoot kbprb KB889541
Feedback