[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Class Not Registered

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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


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.

Install SQL Server 2005 from the Command Prompt
http://msdn2.microsoft.com/en-us/library/ms144259.aspx


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.