SQL Server 2014 Agent 无法启动

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="SQLSERVERAGENT" />
<EventID Qualifiers="49152">324</EventID>
<Level>2</Level>
<Task>4</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-12-08T08:27:13.000000000Z" />
<EventRecordID>5196</EventRecordID>
<Channel>Application</Channel>
<Computer>WSDCB176.nead.danet</Computer>
<Security />
</System>
- <EventData>
<Data>Failed to initialize SQL Agent log</Data>
<Data>Access is denied</Data>
</EventData>
</Event>

解决方法:

给访问目录:X :Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLLogSQLAGENT.OUT (X 为安装SQL Server的盘符)

添加访问权限:

添加:NT ServiceSQLSERVERAGENT 对此文件的完全控制即可。

原文地址:https://www.cnblogs.com/autumn/p/8012407.html