求帮忙：外部组件发生异常（ObjectExplorer）

[yi-yi]

服务器server2003系统，SQL Server2005数据库
问题：sql server management studio链接不上，提示：外部组件发生异常（ObjectExplorer）
求帮忙

[yi-yi]

[發糞塗牆]

你连2008？

[yi-yi]

不是，是2005

[發糞塗牆]

I have a solution for the problem, but I still do not know why it was a problem to begin with. It seems that the IServiceProvider COM object is not registered on the system. I went to a system that this was working properly and exported the following registry entries:

[Copy from HERE]
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"
[ ... TO HERE]

Merging them on the broken system fixed the problem. I would still appreciate anyone shedding some light on the situation, but it works for now.

[Shawn]

用其它机器连，如果SQL SERVER服务没问题。就重装企业管理器。注意：2005可以单独安装企业管理器

[yi-yi]

版主回复的东东我也看懂啊。 求解，求帮忙，急急急

[yi-yi]

telnet是联不上的，重装企业管理器会不会把没有备份的数据丢失？我的数据都学没有备份

[發糞塗牆]

严格来说，那个不叫企业管理器，叫SSMS或者sqlserver management studio，可以单独重装，只是一个客户端工具，跟你的库没关系的。或者你停止sqlservfer服务，把mdf、ldf拷出来，直接重装sqlserver，然后再附加。不过这招比较狠，慎用