none
just-in-time SQL RRS feed

  • Question

  • Hola soy nuevo en el foro y tengo el siguiente problema al querer activar el SQL Server Agent, me manda una ventana con el siguiente mensaje:

    See the end of this message for details on invoking 
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.NullReferenceException: Object reference not set to an instance of an object.

    Server stack trace: 
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.FindObjectExplorerFrame()
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjectExplorer(Boolean activateWindow)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ShowError(Exception e)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
       at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

    Exception rethrown at [0]: 
       at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
       at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ServiceActionHandler.EndInvoke(IAsyncResult result)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ServiceControlProgress.ActionCompletedHandler(IAsyncResult result)


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.8806 (QFE.050727-8800)
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    ----------------------------------------
    ControlService
        Assembly Version: 10.0.0.0
        Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ControlService.exe
    ----------------------------------------
    System
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.8806 (QFE.050727-8800)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Microsoft.NetEnterpriseServers.ExceptionMessageBox
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5495 (Win7SP1GDR.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Microsoft.SqlServer.SString
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SString/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SString.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.8773 (QFE.050727-8700)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    ObjectExplorer
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
    ----------------------------------------
    System.Management
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.8766 (QFE.050727-8700)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
    ----------------------------------------
    System.Data
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.8762 (QFE.050727-8700)
        CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Web
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.8762 (QFE.050727-8700)
        CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
    ----------------------------------------
    Microsoft.SqlServer.SqlTools.VSIntegration
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
    ----------------------------------------
    Microsoft.VisualStudio.Shell.Interop
        Assembly Version: 7.1.40304.0
        Win32 Version: 7.10.6071
        CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
    ----------------------------------------
    Microsoft.VisualStudio.OLE.Interop
        Assembly Version: 7.1.40304.0
        Win32 Version: 7.10.6070
        CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
    ----------------------------------------
    SqlWorkbench.Interfaces
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
    ----------------------------------------
    Microsoft.VisualStudio.Shell
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
    ----------------------------------------
    Microsoft.VisualStudio.Shell.Interop.8.0
        Assembly Version: 8.0.0.0
        Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
        CodeBase: 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
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
        CodeBase: file:///D:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.  

    Este mensaje es el SQL Management Studio, no estoy utilizando Visual Studio, no es un problema con alguna aplicación que esté ejecutando o desarrollando.

    He buscado pero no encuetro algo relacionado.



    SLALO Eduardo S.F.

    Thursday, June 13, 2019 4:25 PM

All replies

  • Hi slalo,

    Welcome to MSDN forum.

    According to this log, it seems that the agent accesses denied. And you should log on right account for the agent. please follow these steps to run it.

    #1 please open Control Panel /System and Security /Administrative Tools /Service

    #2 find "SQLAgent(SQLEXPRESS)", double-click it, then modify the account under "Log on" tag, local account or other specified account

    And I find a similar issue in MSDN forum. Hope it also could help you.

    Any feedback will be expected.

    Best Regards,

    Dylan


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, June 14, 2019 10:58 AM