Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tripodal
Constraint Violating Yak Guru
259 Posts |
 Posted - 2008-09-09 : 10:49:59
|
| 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.is that an issue?Tripodal |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-26 : 04:10:38
|
only if he runs em from the database server.if he runs on his local machine it should be fine.what was broken after installing vb7sp6?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 08:39:13
|
quote:
Originally posted by tripodal
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.is that an issue?Tripodal
Can you explain what do you mean by damaged EM? |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-10-15 : 17:38:34
|
| 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. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-10-16 : 17:22:41
|
| 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!!).Terry |
|
|
|
|
|
|
Enterprise manager