You are currently offline, waiting for your internet to reconnect

Error message when you try to open a project in SQL Server 2008 or in SQL Server 2008 R2: "The located assembly's manifest definition does not match the assembly reference"

SYMPTOMS
When you use SQL Server Management Studio or Windows Explorer to open a recent project in Microsoft SQL Server 2008 or in SQL Server 2008 R2, you receive the following error message:

Class not registered (Exception from HRESULT: 0X80040154(REGDB_E_CLASSNOTREG))
The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

CAUSE
This problem may occur when you run a side-by-side installation of both SQL Server 2008 and SQL Server 2005 Developer Edition or a side-by-side installation of both SQL Server 2008 R2 and SQL Server 2005 Developer Edition .
RESOLUTION

Service pack information for SQL Server 2008

To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008

Service pack information for SQL Server 2008 R2

To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041How to obtain the latest service pack for SQL Server 2008 R2
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was first corrected in SQL Server 2008 Service Pack 2.

This problem was first corrected in SQL Server 2008 R2 Service Pack 1.
Properties

Article ID: 2216460 - Last Review: 04/22/2011 17:56:00 - Revision: 3.0

Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Standard

  • kbinfo kbexpertiseinter kbprb kbbug kbfix kbtshoot kbsurveynew kberrmsg KB2216460
Feedback
play:none;" onerror="var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">