Problems may occur when you try to install SQL Server 2008 R2 Shared Features if the %TEMP% folder is Encrypted.

Problems may occur when you try to install SQL Server 2008 R2 Shared Features if the %TEMP% folder is Encrypted.

  • Comments 2

Symptoms:

You might see a couple of components from the “shared features” failing with the error messages as mentioned below when you are trying to install SQL 2008 R2.

 

Troubleshooting this Issue

=======================

As an end result you will see the setup last screen having failures mentioned in it for a couple of shared feature components. If you open the below log files, you should be seeing similar error messages,

 

Summary.txt
================

MSI status:                    Failed: see details below
MSI error code:                0x1603
MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110421_111052\sql_ssms_loc_Cpu32_1033_1.log
MSI error description:        
MSI status:                    Failed: see details below
MSI error code:                0x1603
MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110421_111052\VS_Shell_Cpu32_1.log
MSI error description:  

     

Detail.txt
========================

2011-04-21 11:16:46 Slp: ----------------------------------------------------------------------
2011-04-21 11:16:46 Slp: Running Action: Install_VS_Shell_Cpu32_Action
2011-04-21 11:16:46 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2011-04-21 11:16:46 Slp: Sco: Attempting to open registry subkey
2011-04-21 11:16:46 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
2011-04-21 11:16:46 Slp: Sco: Attempting to get registry value InstallDir
2011-04-21 11:16:46 Slp: Target package: "C:\SQL 2008 STD ISO\1033_ENU_LP\x86\setup\vs_shell.msi"
2011-04-21 11:17:19 Slp: InstallPackage: MsiInstallProduct returned the result code 1603.
2011-04-21 11:21:10 Slp: ----------------------------------------------------------------------
2011-04-21 11:21:10 Slp: Running Action: Install_sql_ssms_loc_Cpu32_1033_Action
2011-04-21 11:21:10 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2011-04-21 11:21:10 Slp: Sco: Attempting to open registry subkey
2011-04-21 11:21:10 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
2011-04-21 11:21:10 Slp: Sco: Attempting to get registry value InstallDir
2011-04-21 11:21:10 Slp: Target package: "C:\SQL 2008 STD ISO\1033_ENU_LP\x86\setup\sql_ssms_loc.msi"
2011-04-21 11:21:20 Slp: InstallPackage: MsiInstallProduct returned the result code 1603.

 

VS_Shell_Cpu32_1.log
=====================

04/21/11 11:17:17 DDSet_Status: LANGID: 1033
04/21/11 11:17:17 DDSet_Entry: BeginTransaction started
04/21/11 11:17:17 DDSet_Status: LANGID: 1033
04/21/11 11:17:17 DDSet_Entry: CMsHelpObject constructor
04/21/11 11:17:17 DDSet_Error: MsHelpObject::Init()->Failed in opening the file: C:\DOCUME~1\sysadm\LOCALS~1\Temp\HxADB.tmp
04/21/11 11:17:17 DDSet_Error: MsHelpObject::HashEquals()->Hash data is NULL.
04/21/11 11:17:17 DDSet_Error: BeginTransaction()->file authentication has failed.
04/21/11 11:17:17 DDSet_Exit: CMsHelpObject destructor
04/21/11 11:17:17 DDSet_Error: BeginTransaction ERROR: System translation -- Unspecified error. Returned HRESULT -- -2147467259
04/21/11 11:17:17 DDSet_Exit: BeginTransaction ended

 

sql_ssms_loc_Cpu32_1033_1.log
================================

04/21/11 11:21:19 DDSet_Status: LANGID: 1033
04/21/11 11:21:19 DDSet_Entry: BeginTransaction started
04/21/11 11:21:19 DDSet_Status: LANGID: 1033
04/21/11 11:21:19 DDSet_Entry: CMsHelpObject constructor
04/21/11 11:21:19 DDSet_Error: MsHelpObject::Init()->Failed in opening the file: C:\DOCUME~1\sysadm\LOCALS~1\Temp\HxB02.tmp
04/21/11 11:21:19 DDSet_Error: MsHelpObject::HashEquals()->Hash data is NULL.
04/21/11 11:21:19 DDSet_Error: BeginTransaction()->file authentication has failed.
04/21/11 11:21:19 DDSet_Exit: CMsHelpObject destructor
04/21/11 11:21:19 DDSet_Error: BeginTransaction ERROR: System translation -- Unspecified error. Returned HRESULT -- -2147467259
04/21/11 11:21:19 DDSet_Exit: BeginTransaction ended

 

NOTE : Example log files have been shown above for just 2 shared feature components. But you should basically be seeing the same error message for all the failed “shared feature components” when you open their respective log files.

 

Cause:

==========

This issue will occur if the %TEMP% folder on the server is Encrypted.

 

clip_image002

 

Solution:

============

Disable Encryption on the %TEMP% folder.

 

NOTE : Database Engine, Analysis Services, Reporting Services installs fine even if the %TEMP% folder is encrypted.

 

Steps to reproduce.

====================

1> Encrypt the %TEMP% folder using the default windows folder encryption feature.

2> Install SQL 2008 R2.

3> You should encounter the above mentioned errors.

 

Regards,
Dhiraj H N
Support Engineer, Microsoft SQL Server Support

Reviewed by:
Balmukund Lakhani
Technical Lead, Microsoft SQL Server Support

Nickson Dicson
Technical Lead, Microsoft SQL Server Support

Leave a Comment
  • Please add 7 and 8 and type the answer here:
  • Post
  • Thanks for the instructions above. But I checked my %Temp% and it was not encrypted. So I still have the same issue. I would appreciate any advice how to resolve "SQL server 2008 Management Tool" instalation issue.

  • is it a registry value that can be used to identify this ? when it comes to multiple servers ?

Page 1 of 1 (2 items)