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.
After rebuild SQL Server 2005 Registry, we verified that the SQL Server 2008 installation was still functional.
References.
