With a new Windows7 VM on my MBP I have MSSQL Server 2008 R2, vs2008, vs2010…and sadly SourceGear Vault 3.5 which made it so SQL couldn’t connect to a server via the object browser.

Looked like this:

Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface [...]