Wednesday, May 13, 2009

SQL 2008 : Management Studio Error

SQL 2008 : Management Studio fails to launch with the following error following some Windows Updates >



" 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: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop) "

The solution ?

1) Launch a command prompt as Administrator
2) Run regsvr32 actxprxy.dll

It's an ActiveX Interface Marshalling Library (whatever that means!) that needs to be re-registered.

Link : http://msmvps.com/blogs/martinpoon/archive/2009/03/20/ssms-unable-to-cast-com-object-of-type-system-comobject-to-interface-type-microsoft-visualstudio-ole-interop-iserviceprovider-exception-from-hresult-0x80004002-e-nointerface.aspx

No comments: