RE: "mmc could not create the snap-in" launching SQL EM



Hi,
I understand that after MMC 3.0 was installed on your Windows XP SP2, your
SQL Server 2000 Enterprise Manager could not work due to the error "mmc
could not create the snap-in". You also encountered the warning "MMC has
detected an error in a snap-in" when clicked the WMI control snap-in.
If I have misunderstood, please let me know.

After looked through this KB article:
MMC 3.0 update is available for Windows Server 2003 and for Windows XP
http://support.microsoft.com/kb/907265
, I would like to check with you to see if Visual Studio 2005 SP1 has been
installed before you installed MMC 3.0 since this is a prerequisite of
installing MMC 3.0.

For the warning message "MMC has detected an error in a snap-in", I found a
KB article which described the similar issue:
Warning message when you install MMC 3.0 and you are running SQL Server
2000 Analysis Services: "MMC has detected an error in a snap-in."
http://support.microsoft.com/kb/915091
You may check if the workaround can work at your side: Continue running and
always ignore errors with this snap-in, regardless of user or session.

For the error message "mmc could not create the snap-in", I did not find a
article for explaining this error. I also tried installinig MMC3.0 on my
Windows XP Pro SP2, and SQL Server 2000 EM worked fine. As a possible
workaround, I recommend that you reinstall SQL Server 2000 Client Tools to
see if it helps.

If this issue persists, I recommend that you use Process Monitor to monitor
the processes sqlmangr.exe and mmc.exe and mail me
(changliw_at_microsoft_dot_com) the logs for further research.
You can download the tool from this link:
Process Monitor v1.12
http://www.microsoft.com/technet/sysinternals/ProcessesAndThreads/processmon
itor.mspx

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================





.



Relevant Pages

  • Re: Logins created by default
    ... always created automatically during installing a SQL Server using Windows ... Based on my testing in installing SQL Server with Windows Authentication ...
    (microsoft.public.sqlserver.security)
  • Re: Trouble in Windows Firewall
    ... I've installed SP2 on my Windows SBS 2003 R2. ... My question, If error happened in this MMC and then Ignoring that, would my ... Error message when you expand "Publishing Points" in the Windows Media ... I tried to uninstalling ISA Server and then installing again, ...
    (microsoft.public.windows.server.sbs)
  • RE: Error Message When Setup MS SQL Server Developer Edition
    ... I my case it was caused by a problem with MDAC. ... Try downloading and installing the latest ... as you no doubt know running Windows XP without any service pack is not ... My Experience is that the SQL Server developer edition ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL2000 Cluster on Windows 2003 SP1 Cluster
    ... There is one special work-around for installing a named instance on a ... Windows 2003 cluster. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Unable to install SQL Server 2000 on Windows xp Professional SP2
    ... I'm having problems installing SQL Server 2000 Personal Edition on Windows xp ... Professional SP2. ...
    (microsoft.public.sqlserver.setup)

Quantcast