在windows 2008 R2中SQl Server 2008中代理启动失败的一个原因总结

启动sql代理的时候报错如下：

关调用实时(jit)调试而不是此对话框的详细信息，

请参见此消息的结尾。

************** 异常文本

**************

system.nullreferenceexception:

未将对象引用设置到对象的实例。

server stack trace:

在

microsoft.sqlserver.management.ui.vsintegration.objectexplorer.objectexplorer.findobjectexplorerframe()

microsoft.sqlserver.management.ui.vsintegration.objectexplorer.objectexplorer.getobjectexplorer(boolean

activatewindow)

microsoft.sqlserver.management.ui.vsintegration.objectexplorer.objectexplorer.showerror(exception

e)

microsoft.sqlserver.management.ui.vsintegration.objectexplorer.service.start()

system.runtime.remoting.messaging.stackbuildersink._privateprocessmessage(intptr

md, object[] args, object server, int32 methodptr, boolean fexecuteincontext,

object[]& outargs)

system.runtime.remoting.messaging.stackbuildersink.privateprocessmessage(runtimemethodhandle

system.runtime.remoting.messaging.stackbuildersink.asyncprocessmessage(imessage

msg, imessagesink replysink)

exception rethrown at [0]:

system.runtime.remoting.proxies.realproxy.endinvokehelper(message reqmsg,

boolean bproxycase)

system.runtime.remoting.proxies.remotingproxy.invoke(object notused,

messagedata& msgdata)

microsoft.sqlserver.management.ui.vsintegration.objectexplorer.serviceactionhandler.endinvoke(iasyncresult

result)

microsoft.sqlserver.management.ui.vsintegration.objectexplorer.servicecontrolprogress.actioncompletedhandler(iasyncresult

************** 已加载的程序集

mscorlib

程序集版本:

2.0.0.0

win32 版本:

2.0.50727.4984 (win7rtmgdr.050727-4900)

基本代码:

file:///c:/windows/microsoft.net/framework/v2.0.50727/mscorlib.dll

----------------------------------------

controlservice

10.0.0.0

2007.0100.1600.022 ((sql_prerelease).080709-1414 )

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/controlservice.exe

mscorlib.resources

system

2.0.50727.4985 (win7rtmgdr.050727-4900)

file:///c:/windows/assembly/gac_msil/system/2.0.0.0__b77a5c561934e089/system.dll

microsoft.netenterpriseservers.exceptionmessagebox

程序集版本: 10.0.0.0

win32 版本: 10.0.1600.22 ((sql_prerelease).080709-1414 )

file:///c:/windows/assembly/gac_msil/microsoft.netenterpriseservers.exceptionmessagebox/10.0.0.0__89845dcd8080cc91/microsoft.netenterpriseservers.exceptionmessagebox.dll

system.windows.forms

2.0.50727.4986 (win7rtmgdr.050727-4900)

file:///c:/windows/assembly/gac_msil/system.windows.forms/2.0.0.0__b77a5c561934e089/system.windows.forms.dll

system.drawing

file:///c:/windows/assembly/gac_msil/system.drawing/2.0.0.0__b03f5f7f11d50a3a/system.drawing.dll

controlservice.resources

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/zh-chs/controlservice.resources.dll

microsoft.sqlserver.sstring

file:///c:/windows/assembly/gac_msil/microsoft.sqlserver.sstring/10.0.0.0__89845dcd8080cc91/microsoft.sqlserver.sstring.dll

system.xml

2.0.50727.4927 (netfxspw7.050727-4900)

file:///c:/windows/assembly/gac_msil/system.xml/2.0.0.0__b77a5c561934e089/system.xml.dll

objectexplorer

10.0.1600.22 ((sql_prerelease).080709-1414 )

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/objectexplorer.dll

system.management

file:///c:/windows/assembly/gac_msil/system.management/2.0.0.0__b03f5f7f11d50a3a/system.management.dll

objectexplorer.resources

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/zh-chs/objectexplorer.resources.dll

microsoft.netenterpriseservers.exceptionmessagebox.resources

file:///c:/windows/assembly/gac_msil/microsoft.netenterpriseservers.exceptionmessagebox.resources/10.0.0.0_zh-chs_89845dcd8080cc91/microsoft.netenterpriseservers.exceptionmessagebox.resources.dll

system.data

file:///c:/windows/assembly/gac_32/system.data/2.0.0.0__b77a5c561934e089/system.data.dll

system.web

2.0.50727.4971 (win7rtmgdr.050727-4900)

file:///c:/windows/assembly/gac_32/system.web/2.0.0.0__b03f5f7f11d50a3a/system.web.dll

microsoft.sqlserver.sqltools.vsintegration

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/microsoft.sqlserver.sqltools.vsintegration.dll

microsoft.visualstudio.shell.interop

程序集版本: 7.1.40304.0

win32 版本: 7.10.6071

file:///c:/windows/assembly/gac/microsoft.visualstudio.shell.interop/7.1.40304.0__b03f5f7f11d50a3a/microsoft.visualstudio.shell.interop.dll

microsoft.visualstudio.ole.interop

win32 版本: 7.10.6070

file:///c:/windows/assembly/gac/microsoft.visualstudio.ole.interop/7.1.40304.0__b03f5f7f11d50a3a/microsoft.visualstudio.ole.interop.dll

sqlworkbench.interfaces

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/sqlworkbench.interfaces.dll

microsoft.visualstudio.shell

程序集版本: 2.0.0.0

win32 版本: 2.0.50727.1826 (qfe.050727-1800)

file:///c:/windows/assembly/gac_msil/microsoft.visualstudio.shell/2.0.0.0__b03f5f7f11d50a3a/microsoft.visualstudio.shell.dll

microsoft.visualstudio.shell.interop.8.0

程序集版本: 8.0.0.0

win32 版本: 8.0.50727.1826 (qfe.050727-1800)

file:///c:/windows/assembly/gac/microsoft.visualstudio.shell.interop.8.0/8.0.0.0__b03f5f7f11d50a3a/microsoft.visualstudio.shell.interop.8.0.dll

microsoft.sqlserver.management.sdk.sqlstudio

file:///c:/program%20files%20(x86)/microsoft%20sql%20server/100/tools/binn/vsshell/common7/ide/microsoft.sqlserver.management.sdk.sqlstudio.dll

system.windows.forms.resources

win32 版本: 2.0.50727.4927 (netfxspw7.050727-4900)

file:///c:/windows/assembly/gac_msil/system.windows.forms.resources/2.0.0.0_zh-chs_b77a5c561934e089/system.windows.forms.resources.dll

************** jit 调试

要启用实时(jit)调试，

该应用程序或计算机的

.config 文件(machine.config)的 system.windows.forms 节中必须设置

jitdebugging

值。

编译应用程序时还必须启用

调试。

例如:

<configuration>

<system.windows.forms jitdebugging="true"

/>

</configuration>

启用 jit 调试后，任何无法处理的异常

都将被发送到在此计算机上注册的 jit 调试器，

而不是由此对话框处理。

 经过我几天的努力和查找原因：是服务中启动帐户的问题。