Internet Explorer 8 Error: Can’t connect to databases using SQL Management Studio Express 2008

Solution for IE8 Error: Can’t connect to databases using SQL Management Studio Express 2008

Symptoms:

1) Windows Explorer opens folders in new windows, even if you have “Open each window in the same folder” checked;
2) “Open in new tab” doesn’t work in IE8;
3) Can’t connect to databases using SQL Management Studio Express 2008 (”Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. Exception from HRESULT: 0×80004002 (E_NOINTERFACE)”).

Solution:

1) Go to Start -> All Programs -> Accessories, right-click “Command Prompt”, and choose “Run as Administrator”.
2) OK the user access warning dialogs.
3) Enter “regsvr32 actxprxy.dl”.
4) Reboot.