up vote 0 down vote favorite
share [g+] share [fb]

I have an instance of SQL Server 2008 running on a Windows 2008 server. I am able to connect to this SQL server from several machines on my network. However, I cannot connect using SQL Management Studio on the SQL Server itself.

When I hit "Connect" I get this error:

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)

Server config:

  • SQL Server 2005
  • Windows Server 2008 Std 32-bit
  • Also runs SQL Server 2000 on port 1444

I tried:

for %1 in (%windir%\system32*.dll) do regsvr32 /s %1

for %1 in (%windir%\system32*.ocx) do regsvr32 /s %1

  • Running regsvr32 actxprxy.dll, which produced an error

Any ideas?

Justin

link|improve this question
78% accept rate
1  
Do you have Visual Studio installed too? Which version, I have seen this product cause problems with SQL Server 2008 Management Tools IF it was installed AFTER installing SQL Server 2008. – Jeff May 21 '09 at 20:12
@JD - Thanks. I have SQL Server 2005 installed, not 2008. And I do have VS 2005 installed. – Justin May 21 '09 at 20:34
feedback

2 Answers

up vote 2 down vote accepted

unregister actxprxy.dll then reregister it

run 

regsvr32.exe –r c:\windows\system32\actxprxy.dll
regsvr32.exe c:\windows\system32\actxprxy.dll

run these in a command prompt as administrator

On Windows2008 server, the command for unregister is:

 regsvr32.exe /u c:\windows\system32\actxprxy.dll
link|improve this answer
No. SQL Server Management Studio 9 (which is 2005) – Justin May 21 '09 at 20:42
Yah! Thanks. That did it. – Justin May 21 '09 at 20:49
+1 Vote for a correct answer!:-) – MarlonRibunal May 23 '09 at 7:56
feedback
up vote 0 down vote

Sounds like you need to do a repair on your SSMS on your server (if I'm understanding you correctly). I appears that the COM Interfaces need repaired/reinstalled.

-JFV

link|improve this answer
Modify the install from add/remove and remove. Then install workstation components if you don't see repair. – Sam May 21 '09 at 19:43
I tried a repair on Native Client and 2005 itself. Neither worked. – Justin May 21 '09 at 19:44
@Sam - Duh, right. Thanks. – Justin May 21 '09 at 19:47
OK, that didn't work. Any other ideas? – Justin May 21 '09 at 20:33
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.