none
SQL Server 2012 agent will not start after doing an in-place upgrade from SQL Servr 2008 R2

    Question

  • After performing an in-place upgrade from SQL Server 2008 R2 to SQL Server 2012, he SQL Server agent service no longer can start.  In SSMS SQL Server Agent displays (Agent XPs disabled). After searching Google, I ran the script below, which enables them but still the service will not start.

    Additional information is below.  Can anyone suggest a fix?

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

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Agent XPs', 1;

    GO

    RECONFIGURE

    GO

    EXEC SP_CONFIGURE 'show advanced options',0

    GO

    RECONFIGURE

    GO

    Event viewer displays the following:

    MSSQLSERVER, Event ID: 17750

    Could not load the DLL xplog70.dll, or oen of the DLLs it references. Reason: (null).

    I verifed that xplog70.dll exists and even replaced it from a different, working SQL Server 2012 server but it still displays the same message.

    SQLSERVERAGENT, Event ID: 103

    SQLServerAgent could not be started (reason: Failed to load any subsystems. Check errorlog for details.).

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    Unable to start service SQLSERVERAGENT on server SQLSERVER01. (mscorlib)
    ------------------------------
    ADDITIONAL INFORMATION:
    The SQLSERVERAGENT service on SQLSERVER01 started and then stopped. (ObjectExplorer)
    ------------------------------
    BUTTONS:
    OK
    ------------------------------

    Additional information:

    ===================================
    Unable to start service SQLSERVERAGENT on server SQLSERVER01. (mscorlib)
    ------------------------------
    Program Location:

    Server stack trace:
       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.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)

    ===================================
    The SQLSERVERAGENT service on SQLSERVER01 started and then stopped. (ObjectExplorer)
    ------------------------------
    Program Location:
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()

    Thanks,

    Chuck



    Chuck King I.S. Technical Analyst United Regional Health Care System

    Wednesday, July 10, 2013 2:15 PM

All replies

  • Wednesday, July 10, 2013 2:49 PM
    Moderator
  • Thank you Alberto for your reply.  Yes, that is one of the threads I have been using. Using this information, I performed the operations below (with associated output) but my problem still persists.

    I ran the following:

    use msdb
    GO
    sp_set_sqlagent_properties @errorlog_file='D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\SQLAGENT.OUT'
    GO

    Here are the contents of the SQLAGENT.OUT file:

    2013-07-10 10:15:54 - ? [100] Microsoft SQLServerAgent version 11.0.3128.0 (X64 unicode retail build) : Process ID 5452
    2013-07-10 10:15:54 - ? [495] The SQL Server Agent startup service account is URHCS\SCA_AdminSvc.
    2013-07-10 10:15:54 - ? [393] Waiting for SQL Server to recover database 'msdb'...
    2013-07-10 10:15:54 - ? [000]
    2013-07-10 10:15:54 - ? [101] SQL Server URSCADBT01 version 11.00.3128 (0 connection limit)
    2013-07-10 10:15:54 - ? [102] SQL Server ODBC driver version 11.00.3000
    2013-07-10 10:15:54 - ? [103] NetLib being used by driver is DBNETLIB; Local host server is
    2013-07-10 10:15:54 - ? [310] 8 processor(s) and 8181 MB RAM detected
    2013-07-10 10:15:54 - ? [339] Local computer is URSCADBT01 running Windows NT 6.1 (7601) Service Pack 1
    2013-07-10 10:15:54 - ! [298] SQLServer Error: 17750, Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: (null). [SQLSTATE 42000] (ConnCacheSubsystems)
    2013-07-10 10:15:54 - ! [449] Failed to enumerate subsystems (reason: Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: (null). [SQLSTATE 42000] (Error 17750))
    2013-07-10 10:15:54 - ? [432] There are 0 subsystems in the subsystems cache
    2013-07-10 10:15:54 - ! [000] Failed to load any subsystems. Check errorlog for details.
    2013-07-10 10:15:54 - ? [000] Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)  Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)  Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)
    2013-07-10 10:15:54 - ? [098] SQLServerAgent terminated (normally)

    Running the SELECT * FROM msdb..syssubsystems query produces the following:

    subsystem_id    subsystem    description_id    subsystem_dll    agent_exe    start_entry_point    event_entry_point    stop_entry_point    max_worker_threads
    1    TSQL    14556    [Internal]    [Internal]    [Internal]    [Internal]    [Internal]    NULL
    2    ActiveScripting    14555    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLATXSS.DLL    NULL    ActiveScriptStart    ActiveScriptEvent    ActiveScriptStop    NULL
    3    CmdExec    14550    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLCMDSS.DLL    NULL    CmdExecStart    CmdEvent    CmdExecStop    NULL
    4    Snapshot    14551    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLREPSS.DLL    C:\Program Files\Microsoft SQL Server\110\COM\SNAPSHOT.EXE    ReplStart    ReplEvent    ReplStop    NULL
    5    LogReader    14552    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLREPSS.DLL    C:\Program Files\Microsoft SQL Server\110\COM\logread.exe    ReplStart    ReplEvent    ReplStop    NULL
    6    Distribution    14553    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLREPSS.DLL    C:\Program Files\Microsoft SQL Server\110\COM\DISTRIB.EXE    ReplStart    ReplEvent    ReplStop    NULL
    7    Merge    14554    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLREPSS.DLL    C:\Program Files\Microsoft SQL Server\110\COM\REPLMERG.EXE    ReplStart    ReplEvent    ReplStop    NULL
    8    QueueReader    14581    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLREPSS.dll    C:\Program Files\Microsoft SQL Server\110\COM\qrdrsvc.exe    ReplStart    ReplEvent    ReplStop    NULL
    9    ANALYSISQUERY    14513    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLOLAPSS.DLL    NULL    OlapStart    OlapQueryEvent    OlapStop    NULL
    10    ANALYSISCOMMAND    14514    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLOLAPSS.DLL    NULL    OlapStart    OlapCommandEvent    OlapStop    NULL
    11    SSIS    14538    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLDTSSS.DLL    C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTExec.exe    DtsStart    DtsEvent    DtsStop    NULL
    12    PowerShell    14698    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\SQLPOWERSHELLSS.DLL    C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLPS.exe    PowerShellStart    PowerShellEvent    PowerShellStop    2


    Chuck King I.S. Technical Analyst United Regional Health Care System

    Wednesday, July 10, 2013 3:29 PM
  • Hello,

    Could you try to repair SQL Server with the procedure described following article?

    http://msdn.microsoft.com/en-us/library/cc646006(v=sql.110).aspx

    Hope this helps.


     
    Regards,
    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 10, 2013 7:17 PM
    Moderator
  • Yes Alberto, I performed the SQL Server repair but no success and my issue remains. 


    Chuck King I.S. Technical Analyst United Regional Health Care System

    Wednesday, July 10, 2013 7:19 PM
  • Hello,

    Could you try to unregister the DLL and register it again? Use the following article as an example:

    http://support.microsoft.com/kb/241122

    Hope this helps.


     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 10, 2013 7:54 PM
    Moderator
  • Unfortunately, after two weeks this issue is still outstanding.  I have uinstalled SQL Server totally and installed a fresh copy of SQL Server 2012.  This works fine.  When I apply SQL 2012 SP1 the issue returns.  Uninstalling SP1 and rebooting the server removed the issue. 

    So, I have narrowed it down to a SQL 2012 SP1 issue.  Any ideas?


    Chuck King I.S. Technical Analyst United Regional Health Care System

    Wednesday, July 24, 2013 12:53 PM
  • Hello,

    Please read the following article:

    http://support.microsoft.com/kb/955813

    What edition of SQL Server 2012 you installed?

    Could please share any error message found on the following log file:
    \Program files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\SQLAGENT.OUT
     
    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 24, 2013 6:42 PM
    Moderator
  • Hi Chuck,

    I am having a very similar issue with the SQL Server Agent and wondered if you have ever reinstalled SP1 on your server?

    Thanks,

    Beverly Sullivan  DMI DBA

    Tuesday, February 18, 2014 4:49 PM