Some shared components are not installed in the correct folder when you install SQL Server 2005 Express Edition on a computer that is running a 64-bit version of Windows Vista

Article translations Article translations
Article ID: 934750 - View products that this article applies to.
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows registry
Expand all | Collapse all

SYMPTOMS

When you install Microsoft SQL Server 2005 Express Edition on a computer that is running a 64-bit version of Windows Vista, some shared components are not installed in the correct folder. For example, the SqlProv.exe utility is not installed in the correct folder. Additionally, you cannot use the value of the registry entry to locate these shared components.

This problem does not occur if you use a bootstrapping application to run the Sqlexpr.exe Setup file in silent mode.

WORKAROUND

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To work around this problem, change the value of the following registry entry so that it contains the correct location of the folder where the shared components that you want to access are installed:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SharedCode

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

The following is the correct folder:
C:\Program Files (x86)\Microsoft SQL Server\90\Shared
However, some shared components are installed in the following folder:
C:\Program Files\Microsoft SQL Server\90\Shared
The value of the following registry key contains the wrong path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SharedCode
The following is the value of this registry key:
C:\Program Files\Microsoft SQL Server\90\Shared
Therefore, you cannot use the value of the registry entry to locate these shared components.

The value of the following registry entry contains the path of the Program Files folder:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\ProgramFilesDir
The value of the following registry entry contains the path of the Program Files (x86) folder:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\ProgramFilesDir (x86)

Properties

Article ID: 934750 - Last Review: April 13, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 2005 Express Edition
Keywords: 
kbsql2005setup kbsql2005express kbexpertiseadvanced kbtshoot kbprb KB934750

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