You receive a “Class not registered” error after you install SQL Server Management Studio 2008 on a computer running SQL Server Management Studio 2005

Article translations Article translations
Article ID: 961638 - View products that this article applies to.
Expand all | Collapse all
Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Symptom



Consider the following scenario:

1.       You install SQL Server 2005 Management Studio and create a project in SQL Server 2005 Management Studio.

2.       You install SQL Server 2008 Management Studio on the same computer.

 

When you try to open the solution (.ssmssln file) or the project (.ssmssqlproj file) using SQL Server Management Studio 2005, you may get the following error:

“Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))”

 

Resolution



To workaround this issue, use one of the following methods:

 

Method 1:  You can use SQL Server Management Studio 2008 on the same or different system to work with SQL Server Management Studio 2005 projects after the side by side installation.

Method 2:  You can re-install SQL Server Management Studio 2005.

 

However it is advised that client tools like SQL Server Management Studio 2005 and SQL Server Management Studio 2008 be installed on separate systems.

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Properties

Article ID: 961638 - Last Review: January 2, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
Keywords: 
kbnomt kbrapidpub KB961638

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