BUG: Error message when you try to use Visual Studio 2005 to connect to a remote instance of SQL Server after you uninstall SQL Server Management Studio Express (SSMSE): "Class not Registered"

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

If you are still running SQL Server 2005, 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.

This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 431458 (SQLBUDT)
Important This article contains information about how to modify the registry. Make sure to 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 uninstall any one of the following products, registry keys that Microsoft Visual Studio 2005 requires may be removed:
  • SQL Server Management Studio Express (SSMSE) Community Technical Preview
  • Microsoft SQL Server 2005 Express Edition with Advanced Services Community Technical Preview if you selected SSMSE as part of the installation
  • Microsoft SQL Server 2005 Express Edition Toolkit Community Technical Preview if you selected SSMSE as part of the installation
You may receive the following error message when you try to use Visual Studio 2005 to connect to a remote instance of Microsoft SQL Server and then create a database diagram:
Class not Registered
Additionally, Visual Studio 2005 may stop responding.
CAUSE
This issue occurs because SSMSE removes some registry keys that Visual Studio requires during the uninstallation process.
RESOLUTION
To resolve this issue, you must repair the registry. To do this, follow these steps:

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 your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
  1. Download the KB917635.exe package from the Microsoft Download Center. To do this, visit the following Microsoft Web site:
  2. Expand the files when you are prompted by the installer. Click Run if you want to install the new registry file now. Or click Save to install the registry file later.

    By default, the files are expanded to the following folder:
    C:\KB917635
  3. Open the C:\KB917635 folder, and then double-click the SSMSE.reg file to update the registry.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 917635 - Last Review: 12/09/2015 05:24:49 - Revision: 1.1

Microsoft SQL Server 2005 Express Edition with Advanced Services

  • kbnosurvey kbarchive kbsql2005tool kbexpertiseinter kbexpertiseadvanced kbtshoot kbbug KB917635
Feedback