Has anybody had success shooting tethered with a Nikon D800 in Lightroom?
No, see http://forums.adobe.com/thread/1051346
It probably won't be long before it is supported.