SQL Managment Studio Error & Fix

If you have installed SQL Server 2005, and run into a COM error when opening Managment Studio that looks like this:

Unable to cast COM
object of type ‘System.__ComObject’ to interface type
‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation
failed because the QueryInterface call on the COM component for the
interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due
to the following error: No such interface supported (Exception from
HRESULT: 0×80004002 (E_NOINTERFACE)).

the fix is a registry hack: (provided by Nicolas Buse on the MSDN forums)

I’ve pasted the registry section below as much for my reference, as to have another place on the net to locate this little gem. Hope this helps!

[Copy from HERE]
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOTInterface{6D5140C1-7436-11CE-8034-00AA006009FA}]
@=”IServiceProvider”

[HKEY_CLASSES_ROOTInterface{6D5140C1-7436-11CE-8034-00AA006009FA}NumMethods]
@=”4″

[HKEY_CLASSES_ROOTInterface{6D5140C1-7436-11CE-8034-00AA006009FA}ProxyStubClsid32]
@=”{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}”

[HKEY_CURRENT_USERSoftwareClassesInterface{6D5140C1-7436-11CE-8034-00AA006009FA}]
@=”IServiceProvider”

[HKEY_CURRENT_USERSoftwareClassesInterface{6D5140C1-7436-11CE-8034-00AA006009FA}NumMethods]
@=”4″

[HKEY_CURRENT_USERSoftwareClassesInterface{6D5140C1-7436-11CE-8034-00AA006009FA}ProxyStubClsid32]
@=”{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}”

[HKEY_LOCAL_MACHINESOFTWAREClassesInterface{6D5140C1-7436-11CE-8034-00AA006009FA}]
@=”IServiceProvider”

[HKEY_LOCAL_MACHINESOFTWAREClassesInterface{6D5140C1-7436-11CE-8034-00AA006009FA}NumMethods]
@=”4″

[HKEY_LOCAL_MACHINESOFTWAREClassesInterface{6D5140C1-7436-11CE-8034-00AA006009FA}ProxyStubClsid32]
@=”{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}”
[ ... TO HERE]

Simply copy the above text, and put it into a text file with a .reg extension. Then double click the file and click yes on the resulting dialog box.