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

Article translations Article translations
Article ID: 889541 - View products that this article applies to.
Expand all | Collapse all

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'>

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.

Properties

Article ID: 889541 - Last Review: December 17, 2004 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2000 64-bit Edition
Keywords: 
kbtshoot kbprb KB889541

Give Feedback

 

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