登入
Microsoft.com
 
Microsoft
 
 
 

none
Cannot use SQL 2000 Enterprise manager. Error "MMC could not create the snap-in" RRS feed

 > 

  • 問題

  • Question
    登入以投票
    0
    登入以投票
    Hi

    I am experiencing a problem after installing "run-time support for DTS package" and "design-time support for DTS Package" on SQL Server 2008 Management Studio basic.

    I has a Win XP Pro,
    I has SQL 2000 Enterprise Manager and SQL 2008 Management Studio Basic.
    Both of them use to work fine. Today I want to try to run DTS Via Management Studio, therefore I has downloaded 2 package from the following artical, http://msdn.microsoft.com/en-us/library/bb500440.aspx

    After I installed both package, I can view and run DTS from Management Studio 2008. When I try to use SQL 2000 Enterprise manager to view data. It return a lot of error. Then It displays MMC could not create the snap-in on one of the windows inside Enterprise manager.

    I would be grateful if you can let me know is there any way I can solve that problem.

    Thanks in advance
    2008年11月6日 下午 09:46
    |

解答

  • Question
    登入以投票
    0
    登入以投票
    Hi,

    I had kind of solved the problem, by using System restore. To restore the computer back to before I install any DTS component.

    Not sure it I can make DTS work for both Management Studio and Enterprise Manager.

    2008年11月7日 上午 09:20
    |

所有回覆

  • Question
    登入以投票
    0
    登入以投票
    Hi,

    I had kind of solved the problem, by using System restore. To restore the computer back to before I install any DTS component.

    Not sure it I can make DTS work for both Management Studio and Enterprise Manager.

    2008年11月7日 上午 09:20
    |
  • Question
    登入以投票
    0
    登入以投票

    Hi

     

    We have the same problem and resolve it by this way:

     

    regsvr32 /u "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Dtsui.dll"

    regsvr32 /u "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqldmo.dll"
    regsvr32 /u "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqlns.dll"
    regsvr32 /u "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqllex.dll"
    regsvr32 /u "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqlmmc.dll"
    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Dtsui.dll"
    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqldmo.dll"
    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqlns.dll"
    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqllex.dll"
    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\binn\Sqlmmc.dll"

     

     

     

    2008年12月17日 上午 08:50
    |
  • Question
    登入以投票
    0
    登入以投票
    Thanks...buddy...saved my day... Smile
    2009年1月26日 下午 10:47
    |