Return
-
Title
Agent not logging events in the database -
Description
AA Agents installed on the DCs no events logged on the DB other than agent activity.
Errors on the agent log
error locating server / instance specified
Server doesn't support requested protocol
-
Cause
Missing SQL 2012 native client on the DCs
SQL Express by default doesn't turn on SQL Browser service
By default Network protocols Named Pipes and TCP / IP are disabled.
-
Resolution
Install SQL 2012 native client on the DCs
https://www.microsoft.com/en-us/download/details.aspx?id=50402
On the SQL Express configuration manager start the SQL Browser service and enable the Network Protocols
- Named Pipes
- TCP / IP
The agents will start to send the events when this conditions are met.