Monitor unlimited number of servers
Filter log events
Create email and web-based reports

Direct access to Microsoft articles
Customized keywords for major search engines
Access to premium content

Event ID: 102 Source: SQLServerAgent

Level
Description
SQLServerAgent service successfully stopped.
Comments
 
Check SQL Agent Properties in Management studio and verify error log location. We had this problem after failed drive when the path wasn't set on the new drive.
It is a rights issue. I have added the user under which the agent runs as a local admin and it worked. Best answer will be to see exactly what kind of rights it needs.
If this event occurs after starting the SQL server:

1. Check the error log file at C:\Program Files\Microsoft SQL Server\<instance_folder>\MSSQL\LOG.
2. Using SQL Server Management Studio, connect to the server and try to start the SQL agent. If the SQL agent indicates "agent XPs disabled", there is a configuration error or service account issue that is preventing SQL agent from running.
A. Run the following to re-enable SQL agent:
sp_configure "show advanced options", 1;
GO
RECONFIGURE;
GO
sp_configure "Agent XPs", 1;
GO
RECONFIGURE;
GO
B. Do not attempt to start SQL Agent yet. Resolve the SQL Agent issue before starting SQL Agent.

You can use SQL Server Configuration Manager to check the SQL Agent service account. Make sure it is set to an account that has proper permissions. This was the cause in my case.

Windows Event Log Analysis Splunk App

Build a great reporting interface using Splunk, one of the leaders in the Security Information and Event Management (SIEM) field, linking the collected Windows events to www.eventid.net.

Read more...

 

Cisco ASA Log Analyzer Splunk App

Obtain enhanced visibility into Cisco ASA firewall logs using the free Firegen for Cisco ASA Splunk App. Take advantage of dashboards built to optimize the threat analysis process.

Read more...