<< Enabling Outlook Instant Search on Windows Server 2008 | Home | Fixing "Unable to connect publishing custom string handler for output caching" >>

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

 

posted @ Friday, July 31, 2009 3:08 PM

Print

Comments on this entry:

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by Mike.Blurton at 1/5/2010 4:00 PM
Gravatar
I'm having the same problem, running windows 7 pro, vs2008 and ssms 2008, the regsvr32 fix did not work for me.

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by Michael K. Campbell at 2/6/2010 12:52 AM
Gravatar
Same here. Brand new install of Win 7 Pro, VS 2008, and SSMS 2008. Tried all the various registry hacks, absolutely no love.

And searching shows that gobs of folks have this issue. With MS would create a fix....

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by Art at 3/26/2010 3:29 PM
Gravatar
The problem is with Vault

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by adriana at 4/30/2010 3:13 PM
Gravatar
what is the vault? how can i find it? please help...ive done everything but still cant make integration services to work... sitll have the same error please help

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by cheap laptops pc at 5/11/2010 5:02 AM
Gravatar
Windows Server 2008 R2 is a server operating systme released by Microsoft. It was launched during oct 2009. It comes with new upgradations like Active Directory, new Virtualization and Management features.

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by saç ekimi merkezleri at 5/12/2010 11:40 AM
Gravatar
Hi;
Unfortunately, although I realize I could not read the topic defalrca to help me in this regard would be glad if the mail.
mary lou
marylou23@gmail.com CCCDD

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by saç ekimi at 5/13/2010 4:51 AM
Gravatar
Hi all;
requirements and should not be on this blog first of this sitesiyi inceledigimiz evden eve nakliyat
errors than we do with a good opportunity to face the other blog ankara evden eve nakliyat
a quality that is important for us as we serve our hair, so take your time and valuable friend in you saç ekimi
whatever you call it the sac ekimi ve evden eve nakliyat most beautiful sites....

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by unlimited mobile broadband at 5/22/2010 3:49 AM
Gravatar
The central core of SQL Server Mangement Studio is its Object Explorer. This helps the user to browse, select and stay with any object with in the server.

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by Abel Fontes at 6/1/2010 6:39 PM
Gravatar
REGSVR32 "C:\Program Files (x86)\Internet Explorer\ieproxy.dll"

Fixed me.

Running Windows 7 x64.

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by Hosting at 6/18/2010 3:51 AM
Gravatar
I managed to do it!! That was a challenge! :)

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by Company XXXX at 6/28/2010 4:57 PM
Gravatar
We had this same problem on one of our Windows 7 x64

the "REGVR32 "C:\Program Files\Internet Explorer\ieproxy.dll worked

2 important things:
1. normal Program Files (NOT x86) worked, though (x86) was NOT attempted before problem was resolved.
2. make sure that you load command prompt as ADMIN.

Thanks a ton Abel Fontes for the help, and everyone else, of course!

# # re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by ankara nakliyat at 7/12/2010 7:27 AM
Gravatar

# re: SQL Server Management Studio "Unable to Cast COM of Type ..."

Left by learn vedic math at 7/17/2010 2:01 AM
Gravatar
This is very good explanation but still some people need simple explanation to understand....

Your comment:



 (will not be displayed)


 
 
 
Please add 6 and 4 and type the answer here:
 

Live Comment Preview:

 
«July»
SunMonTueWedThuFriSat
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567
About
Syndication:

RSS ATOM