Microsoft KB Archive/889541

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

Article ID: 889541

Article Last Modified on 12/17/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 64-bit Edition

-





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

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



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:  Create a folder at the root of the local drive and name it TEMP. Click Start, right-click My Computer, and then click Properties.</li> In the System Properties dialog box, click the Advanced tab.</li> Click Environment Variables.</li> Repeat the following steps for both the TEMP and the TMP User variables: <ol style="list-style-type: lower-alpha;"> In the User variables list, select the TEMP variable, and then click Edit.</li> In the Variable value box, type \TEMP, and then click OK.

Note is the local drive where you created the folder in step 1.</li> Repeat steps a and b for the TMP variable, if it exists.</li></ol> </li> Repeat the following steps for both the TEMP and the TMP System variables: <ol style="list-style-type: lower-alpha;"> In the System variables list, select the TEMP variable, and then click Edit.</li> In the Variable value box, type \TEMP, and then click OK.

Note is the local drive where you created the folder in step 1.</li> Repeat steps a and b for the TMP variable, if it exists.</li></ol> </li> Click OK two times to close the System Properties dialog box.</li> Click Start, click Run, type cmd in the Open box, and then click OK.</li> At the command prompt, type the following command to verify that the TEMP and the TMP environment values are equal to \TEMP :

set t

Note  is the local drive where you created the folder in step 1.

</li> 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

</li></ol>

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.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: SQLSERVER IA64 AMD64

Keywords: kbtshoot kbprb KB889541

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.