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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Side-by-side upgrade ruined Enterprise Manager

Author  Topic 

ds9
Starting Member

38 Posts

Posted - 2007-12-11 : 11:36:29
Hi people

Here is my case: I've a server running Windows server 2003 edition and SQL2000.
I've installed SQL2005 using the side-by-side method as described by MSFT docs. I've then copied the mdf & ldf files to new locations and attached the db in SQL 2005 management studio. Every thing fine. Next, I've migrated the DTSs using the DTS migration wizard. After this step I have some bad warnings in windows:

When I restart the server I get the following message: "mmc.exe Microsoft Management Console encountered a problem and needed to close".
Furthermore: I can't start the old SQL enterprise manager.
It shows another error "mmc.exe - Entry point Not Found" and closes it self.

The MSFT support page on this error relates it to Windows XP but my system is running Windows server....

Any one has any idea why this is happening?
Any suggested course of action?

Many thanks
ds9

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-11 : 22:43:53
Reinstall sql2k tools again.
Go to Top of Page

ds9
Starting Member

38 Posts

Posted - 2007-12-12 : 06:46:06


I've installed SQ2K SP4 and all issue cleared.


Cheers
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-12 : 07:41:04
What if you tried to post some feedback here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93963

so we can see if our efforts was a waste of time or not.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -