Post reply

MMC.EXE Entry point not found ....Enterprise Manager failing on XP client

  • April 27, 2005 at 5:21 am

    #92945

    I have installed Enterprise manager on an XP workstation. Install completed OK.

    However when I start Enterprise manager I get error MMC.exe Entry Point not found.The procedure entry point ? ProcessExecute @@YAXPAUHWND__@@PBG1@2 could not be located in the dll SEMSFC.DLL

    Has anyone come across this before and have a fix please?

    Thanks

  • April 27, 2005 at 7:28 am

    #555203

    Try uninstall and reinstall.

  • April 28, 2005 at 1:13 am

    #555443

    I had the same issue. It didn't resolve until i re-install the sql server.!




    My Blog: http://dineshasanka.spaces.live.com/

  • May 2, 2006 at 1:29 pm

    #635444

    I tried uninstalling and reinstall, but the error doesn't go. Is it related to Service Patches?

  • June 9, 2006 at 11:16 am

    #642861

    Hi,

    Does anybody has a solution for this please.

     

  • June 9, 2006 at 2:29 pm

    #642918

    You installed SQL Server 2000 Enterprise Manager on a workstation with SQL Server 2005 Management Studio already installed. 

    You cannot run them side-by-side.  Best case is to follow these instructions:

    http://blogs.msdn.com/mab/archive/2006/03/18/554466.aspx

    Hope this helps

     



    Mark

  • July 31, 2006 at 11:29 am

    #652437

    Not entirely correct. You can run both side by side without any issues whatsoever UNTIL you install the "SQL 2000 DTS Designer Components" for SQL 2005 Management Studio. I made the mistake of doing so while comparing the capabilities of the two in order to see which application would best suit my needs. Oops!

    If you need both, edit packages in 2000 DTS Designer and don't install this add-in for 2005 Management Studio.

  • August 3, 2006 at 5:16 pm

    #653230

    I probably don't need to say this is a real pain in the a?? and a warning before installing the Add-In was due.

    The fact that a basic MMC Manage command does not work on your workstation is just scarry.

    I did, however, get it to work following Mark's steps. That is, I can use DTS packages from both angles - EM and Management Studio.


    {Francisco}

  • August 15, 2006 at 2:00 am

    #655011

    It is true that the dts components for 2005 does in fact cause the screw up.

    However, you can get over this by installing sql server 2000 service pack 4. Worked for me and for everyone else on my team.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • April 26, 2007 at 3:47 pm

    #702812

    Yeah this really sucks.  Just trying to evaluate the 2005 DTS sent my working installation south.  I reinstalled the MMC from the CD: NO JOY!!

    Installed sp3 after that: JOY!!!

    A warning is definitely needed!

  • May 11, 2007 at 6:39 am

    #705792

    Yes, I have teh same problem and just reinstalling SQL 2000 SP4 worked!!

     

    Thanks for every all

  • April 22, 2008 at 8:32 pm

    #805849

    If by no means SQL 2000 SP4 and SP3 are not fixing this error then you need to do a clean install:

    - install SQL 2000 client

    - install SQL 2005 server

    - install sqlserver2005_dts.msi

    Then

    - uninstall all of the above (I sequentially uninstalled 2000, 2005 and the dts addins)

    - reinstall SQL 2000 and try EM - it should now work

    - you then can reinstall SQL 2005 server but NOT sqlserver2005_dts.msi

    You might have to do few reboots in the process (I did 1 after uninstalling everything).

    Hope it helps

    T

  • August 7, 2008 at 12:34 pm

    #854692

    I'm having the same issue but applying and reapplying SP 4 did not work. Any suggestions?

  • August 7, 2008 at 5:07 pm

    #854831

    You probably need to follow the steps mentioned above in a sequential order. It took me a while to make it work and I still dont have a clear understanding of what had happened. Applying and re-applying the SP did not solve the problem (ie I did not apply SP 4 for sql 2000, only until SP 3a).

    you need to uninstall everything and do a clean install.

  • August 8, 2008 at 8:14 am

    #855207

    I was able to get it working partically using the steps outlined. The only other thing that I did was to physcialy remove the entire MSSQL folder (actually moved it to a different drive) before rebooting. Once that was completed and after several other reboots EM was working again. I then installed SP4 and all is well so far.

    Thanks for the help.

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply