SQL Server Management Studio “Unable to Cast COM of Type …”

Ugh! I am stuck in Windows Registry hell. Here is the situation. I have a Windows Server 2008 R2 Standard Edition install running SQL Server 2008 SP1 and Visual Studio.NET 2008 SP1. It seems that with this configuration I get the following error in SQL Server Management Studio (SSMS).


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)

After doing some searching it appears that this is a result of Windows registry corruption that can be solved by re-registering the actxprxy.dll (you need to open the command line running as administrator and run ‘regsvr32 actxprxy.dll’).  There are serveral blog posts that document this solution (below are a few links).  Unfortunately for me this did not fix my problem and I haven’t been able to find a fix making SSMS unusable.  The irony of this situation is that I have a laptop with the exact same problem and it is running Windows 7 RC1 with SQL Server 2005 and Visual Studio.NET 2008 so the common demoninator appears to be VS.NET 2008.  I an anxious to see if others are having this problem if the above workaround was successful for them or not.

http://www.thisispaulsmith.co.uk/BLOG/post/SQL-Server-Management-Studio-Error-Unable-to-cast-COM-objecthellip3b.aspx

http://support.microsoft.com/kb/922214

http://blog.newslacker.net/2008/02/sql-server-2005-unable-to-cast-com.html

 

Leave a Comment

Your email address will not be published. Required fields are marked *