在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 調試器，

而不是由此對話框處理。

 經過我幾天的努力和查找原因：是服務中啟動帳戶的問題。