We had to format his machien in order to get enterprise manager working again. Perhaps there was a better way, or maybe there were more issues he didnt tell us about it previously.
But examples, woudl be errors when starting up EM. Missing components. Unable to start the analysis services.
Sorry for the delay in response.
What we believe happened, is that the VB Dll's that enterprise manager uses were overwritten by the visual basic 6.0 installer. The versions being incorrect basically blew up Enterprise Manager. I unfortunately didnt get the change to fix it myself and delagated it down. Too bad.
Believe it or not, I had clients at different sp levels and the same data requests using QA actually returned different result sets. That was a tough one to figure out (it took us a couple of days). We were relieved it wasn't corruption or the like. Ever since, I try to ensure client machines are at the same sp level as the server (not much of an issue now as we're on S2K sp4 are there aren't anymore sps coming out!!).