1

Topic: Not SQL the agent

Recently noted that automatically it is not launched SQLServerAgent
Here after reboot such state:
http://images.vfl.ru/ii/1519989443/bac5 … 794264.jpg
The manual is launched!
Here a broad gull of the agent:

2018-03-02 8:35:17 AM-? [100] Microsofts SQLServerAgent of version 13.0.4466.4 (assembly X64 unicode commercial): a process identifier 6340
2018-03-02 8:35:17 AM-? [495] Security account of service of start of the agent of a SQL Server is equal NT Service\SQLSERVERAGENT.
2018-03-02 8:35:17 AM-? [393] recovery of databases "msdb" a SQL Server Is expected...
2018-03-02 8:35:17 AM-? [000]
2018-03-02 8:35:17 AM-? [101] SQL Servers SRV3 of version 13.00.4466 (with restriction on 0 connections)
2018-03-02 8:35:17 AM-? [102] ODBC-driver for version 13.00.4466 SQL Server
2018-03-02 8:35:17 AM-? [103] As library NetLib by the driver it is used DBNETLIB; the local server of a node:
2018-03-02 8:35:17 AM-? [310] 6 processors and 32656 MB of the RAM Are revealed
2018-03-02 8:35:17 AM-? [339] Local computer SRV3 works with Windows NT 6.2 (9200)
2018-03-02 8:35:17 AM-? [432] In a cache of subsystems there are 7 subsystems
2018-03-02 8:35:18 AM-? [129] SQLSERVERAGENT it is launched by means of a control facility services NT Windows
2018-03-02 8:35:18 AM - + [475] Components Database Mail it is not included for notification messages of the agent.
2018-03-02 8:35:18 AM - + [396] the condition of idle time of the processor is not defined - schedules of jobs of type OnIdle will not be used
2018-03-02 10:59:11 AM-? [130] Stop SQLSERVERAGENT in connection with end of operation Windows...
2018-03-02 10:59:12 AM-! [298] Error SQLServer: 21, Encryption not supported on the client. [SQLSTATE 08001]
2018-03-02 10:59:12 AM-! [298] Error SQLServer: 773, SSL Provider: the Requested packet of safety does not exist [SQLSTATE 08001]
2018-03-02 10:59:12 AM-! [298] Error SQLServer: 21, Client unable to establish connection [SQLSTATE 08001]
2018-03-02 10:59:12 AM-! [298] Error SQLServer: 773, A network-related or instance-specific error has occurred while establishing a connection to a SQL Server. Server is not found or not accessible. Check if instance name is correct and if a SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [SQLSTATE 08001]
2018-03-02 10:59:12 AM-! [382] Input on the server "(local)" was completed unsuccessfully (SaveAllSchedules)
2018-03-02 10:59:13 AM-! [298] Error SQLServer: 21, Encryption not supported on the client. [SQLSTATE 08001]
2018-03-02 10:59:13 AM-! [298] Error SQLServer: 773, SSL Provider: the Requested packet of safety does not exist [SQLSTATE 08001]
2018-03-02 10:59:13 AM-! [298] Error SQLServer: 21, Client unable to establish connection [SQLSTATE 08001]
2018-03-02 10:59:13 AM-! [298] Error SQLServer: 773, A network-related or instance-specific error has occurred while establishing a connection to a SQL Server. Server is not found or not accessible. Check if instance name is correct and if a SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [SQLSTATE 08001]
2018-03-02 10:59:13 AM-! [382] Input on the server "(local)" was completed unsuccessfully (DisableAgentXPs)
2018-03-02 10:59:13 AM-? [098] SQLServerAgent it is interrupted. (Normally)

2018-03-02 8:35:18 AM - I then manual launched the agent
2018-03-02 10:59:12 AM - were rebooted by the server.
In WIN broad gulls there is nothing explicitly about SQL the agent, only here when the manual launch the agent, there is such error:

Log name: System
Source: Microsoft-Windows-DistributedCOM
Date: 3/2/2018 of 1:12:35 PM
Event code: 10016
Category :
Level: the Error
Key :
The user: NT SERVICE\SQLSERVERAGENT
The computer: srv3
The description:
Parameters of resolutions for specific application do not give resolution Locally Activation for application of the COM-server with CLSID
{D63B10C5-BB46-4990-A94F-E40B9D520160}
And APPID
{9CA88EE3-ACB7-47C8-AFC4-AB702511C276}
To user NT SERVICE\SQLSERVERAGENT with  to safety (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430) and LocalHost address (with usage LRPC), application executable in the container it is inaccessible with  to safety (Unavail). This resolution of safety can be changed by means of an administrative tool of services of components.
Xml events:
<Event xmlns = "http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name = "Microsoft-Windows-DistributedCOM" Guid = "{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName = "DCOM"/>
<EventID Qualifiers = "0"> 10016 </EventID>
<Version> 0 </Version>
<Level> 2 </Level>
<Task> 0 </Task>
<Opcode> 0 </Opcode>
<Keywords> 0x8080000000000000 </Keywords>
<TimeCreated SystemTime = "2018-03-02T10:12:35.704370300Z"/>
<EventRecordID> 16820 </EventRecordID>
<Correlation/>
<Execution ProcessID = "844" ThreadID = "6920"/>
<Channel> System </Channel>
<Computer> srv3 </Computer>
<Security UserID = "S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430"/>
</System>
<EventData>
<Data Name = "param1"> for specific application </Data>
<Data Name = "param2"> it is local </Data>
<Data Name = "param3"> Activation </Data>
<Data Name = "param4"> {D63B10C5-BB46-4990-A94F-E40B9D520160} </Data>
<Data Name = "param5"> {9CA88EE3-ACB7-47C8-AFC4-AB702511C276} </Data>
<Data Name = "param6"> NT SERVICE </Data>
<Data Name = "param7"> SQLSERVERAGENT </Data>
<Data Name = "param8" >S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430</Data>
<Data Name = "param9"> LocalHost (with usage LRPC) </Data>
<Data Name = "param10"> it is inaccessible </Data>
<Data Name = "param11"> it is inaccessible </Data>
</EventData>
</Event>

But at itself did not find SQLSERVERAGENT the security account.