• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3838
  • Last Modified:

MMC could not create the snap-in for Microsoft SQL Enterprise Manager CLSID {full number}

Expert,

I installed Microsoft SQL server 2k, then I tried to spend console root and Microsfot SQL servers, it showed me the error like:
MMC could not create the snap-in for Microsoft SQL Enterprise Manager CLSID {full number}. How can I fix this?

Thanks
0
yrcdba7
Asked:
yrcdba7
  • 4
2 Solutions
 
yrcdba7Author Commented:
expert,

I searched your web followed this.  Go to Start\Run. Type mmc. Click on OK.
Go to File/Add-Remove Snap-in. Click on Add. Select Microsoft SQL Enterprise Manager from the list. the popping out windowns on Microsoft Managerment Console
Name: Microsoft SQL Enterprise Manger
CLSID: {******-****-******}.
I use windows server 2003 and SP2.
I also tried to download .net3.5, it doesn't work.

Any other idear?
jc
0
 
yrcdba7Author Commented:
some suggestion is reinstall IE, I did but no work.
0
 
yrcdba7Author Commented:
I also copied SQL Server Enterprise Manager.msc from CD to local drive

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\.. to replace this local file which I could not open, then I tried to open EM again, it still is the same error.  Please help!

JC

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
yrcdba7Author Commented:
I have tried reinstall .NET framework 3.5, it doesn't help.
0
 
QlemoC++ DeveloperCommented:
Did you try a repair install of MSSQL Client Tools yet?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Installing SQL Server 2000 SP4 resolves this issue.

http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en

Or

Have you uninstalled SQL Server 2005 from that machine. That might have uninstalled backward compatibility and hence you might face this issue.

http://support.microsoft.com/kb/914157
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now