none
SQL Server 2008 Enterprise SP2 on Windows 2008 R2 Enterprise, SQL Agent can not be started

    Question

  • Hi,

    SQL Server engine is up and running with no issues. But the SQL Server Agent fails to start and the only information given is Error Message:%%5

     

    Security is not the problem, it uses the same account as the engine.

     

    Quite frankly, I have no idea where to start.  the %%5 is also a major source of errors in .Net.

     

    Does anyone have any ideas? Like I said I am stumped.

     

    Thanks!

     

    David


    David Eaton
    Tuesday, January 11, 2011 11:11 PM

Answers

  • Hi

     

    There are no issues with security, I have verified that already.

    This all I get and it is only in the Windows event log:

     

     

    Message

    The description for Event ID '-1073734824' in Source 'Service Control Manager' cannot be found.  The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them.  The following information is part of the event:'SQL Server Agent (MSSQLSERVER)', '%%5'

     

     

    This was for a new installation of SQL Server 2008 Enterprise Edition with SP 2 on Windows 2008 R2 Enterprise Edition

     

    This is the error message text when I try to srtat the SQL Server Agent

     

     

    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.4952 (win7RTMGDR.050727-4900)

        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:///C:/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.4927 (NetFXspW7.050727-4900)

        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.2531.0 ((Katmai_PCU_Main).090329-1045 )

        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.4927 (NetFXspW7.050727-4900)

        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.4927 (NetFXspW7.050727-4900)

        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.4927 (NetFXspW7.050727-4900)

        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.4000.0 ((Katmai_PCU_Main).100916-1939 )

        CodeBase: file:///C:/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.4927 (NetFXspW7.050727-4900)

        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.4927 (NetFXspW7.050727-4900)

        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.4955 (win7RTMGDR.050727-4900)

        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.4000.0 ((Katmai_PCU_Main).100916-1939 )

        CodeBase: file:///C:/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.2531.0 ((Katmai_PCU_Main).090329-1015 )

        CodeBase: file:///C:/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:///C:/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.


     


    David Eaton
    • Marked as answer by David Eaton Wednesday, January 12, 2011 11:10 PM
    Wednesday, January 12, 2011 4:20 PM

All replies

  • What error message do you see in the application event log, also is there anything useful in the agent error log, have a look under MSSQL\LOG which is usually where it is, SQLAGENT.OUT should be the log name. Also can you check the SQL Server error log. Hopefully there is something more useful than %%5. Can you double check that you can connect using the account the Agent is running under using Management Studio and browse MSDB etc.

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    Wednesday, January 12, 2011 1:55 AM
  • Hi

     

    There are no issues with security, I have verified that already.

    This all I get and it is only in the Windows event log:

     

     

    Message

    The description for Event ID '-1073734824' in Source 'Service Control Manager' cannot be found.  The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them.  The following information is part of the event:'SQL Server Agent (MSSQLSERVER)', '%%5'

     

     

    This was for a new installation of SQL Server 2008 Enterprise Edition with SP 2 on Windows 2008 R2 Enterprise Edition

     

    This is the error message text when I try to srtat the SQL Server Agent

     

     

    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.4952 (win7RTMGDR.050727-4900)

        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:///C:/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.4927 (NetFXspW7.050727-4900)

        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.2531.0 ((Katmai_PCU_Main).090329-1045 )

        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.4927 (NetFXspW7.050727-4900)

        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.4927 (NetFXspW7.050727-4900)

        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.4927 (NetFXspW7.050727-4900)

        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.4000.0 ((Katmai_PCU_Main).100916-1939 )

        CodeBase: file:///C:/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.4927 (NetFXspW7.050727-4900)

        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.4927 (NetFXspW7.050727-4900)

        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.4955 (win7RTMGDR.050727-4900)

        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.4000.0 ((Katmai_PCU_Main).100916-1939 )

        CodeBase: file:///C:/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.2531.0 ((Katmai_PCU_Main).090329-1015 )

        CodeBase: file:///C:/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:///C:/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.


     


    David Eaton
    • Marked as answer by David Eaton Wednesday, January 12, 2011 11:10 PM
    Wednesday, January 12, 2011 4:20 PM
  • I'm having the same issue did you find a solution?
    Wednesday, February 09, 2011 3:56 PM
  • I'm having the same issue  any one find a solution?
    Monday, July 01, 2013 5:18 PM