You are currently offline, waiting for your internet to reconnect

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

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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
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: 04/13/2007 21:23:46 - Revision: 1.1

Microsoft SQL Server 2005 Express Edition

  • kbsql2005setup kbsql2005express kbexpertiseadvanced kbtshoot kbprb KB934750
Feedback