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 Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\SQLAGENT.OUT (X 为安装SQL Server的盘符）

添加访问权限:

添加：NT Service\SQLSERVERAGENT 对此文件的完全控制即可。

转载于:https://www.cnblogs.com/autumn/p/8012407.html