Being relatively weakminded in all things sql. My question today is, does enterprise manager recieve the service packs you would normally apply to the SQL server itself?
I have a users who installed vb 7 service pack 6 and it damaged his enterprise manager.
He reinstalled Enterprise Manager from a sql2000 sp3 cd. But our sql server is 2000 sp4.
Being relatively weakminded in all things sql. My question today is, does enterprise manager recieve the service packs you would normally apply to the SQL server itself?
I have a users who installed vb 7 service pack 6 and it damaged his enterprise manager.
He reinstalled Enterprise Manager from a sql2000 sp3 cd. But our sql server is 2000 sp4.
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!!).
Enterprise manager
Posted - 09/09/2008 : 10:49:59
