SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Enterprise manager
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 09/09/2008 :  10:49:59  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
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

Sweden
30265 Posts

Posted - 09/26/2008 :  04:10:38  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 09/26/2008 :  08:39:13  Show Profile  Reply with Quote
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?
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 10/15/2008 :  17:38:34  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
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.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 10/16/2008 :  17:22:41  Show Profile  Reply with Quote
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

Edited by - tosscrosby on 10/16/2008 17:23:34
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000