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:
- Uninstalling and reinstalling SQL Management Studio
- Adding these registry entries
- Rebooting
- Running these commands:
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
Best Answer
unregister actxprxy.dll then reregister it
run
run these in a command prompt as administrator
On Windows2008 server, the command for unregister is: