Class Not Registered (Microsoft.SqlServer.SqlTools.VSIntegration)

最新推荐文章于 2025-05-08 15:56:01 发布

转载最新推荐文章于 2025-05-08 15:56:01 发布 · 739 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：http://www.cnblogs.com/liuzijing688/archive/2008/01/30/1058982.html

标签

#数据库

本文解决安装SQL Server 2008后，使用SQL Server Management Studio 2005打开表时出现的“Class not registered”错误。通过重建SQL Server 2005注册表来修复。

Applies to: Microsoft SQL Server 2005, Windows Server 2003, SQL Server Management Studio 2005.
Error Message.
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
(Microsoft.SqlServer.SqlTools.VSIntegration)

Cause.
This error came when we try to open a table with SQL Server Management Studio 2005 after installing SQL Server 2008 (Katmai - CTP November 2007) for testing purposes on the same machine.

Solution.

Rebuild SQL Server 2005 Registry running setup from the command prompt with the REINSTALL=ALL and REINSTALLMODE=omus parameters.
The following example assumes setup is localed at the C:\SQLDev folder and it is not located at a DVD/CD drive.
Example:
Start /wait C:\SQLDev\setup.exe /qb INSTANCENAME=(local) REINSTALL=ALL REINSTALLMODE=omus SAPWD=password
The following images illustrate the execution of this command.