Share with together

独乐乐不如众乐乐

博客园 首页 新随笔 联系 订阅 管理

- <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 对此文件的完全控制即可。

posted on 2017-12-09 19:09  寒枫  阅读(2301)  评论(0编辑  收藏  举报