Event ID 17187 error appears in the application event log on the Active Administrator server after a reboot. This event means SQL Server is not ready to accept new client connections. Due to this issue, all Active Administrator tasks failed. SQL and Active Administrator installed on same 2008 R2 server.
Set the Active Administrator Foundation Service to automatic (Delayed Startup).
If issue persists, add the following registry key:
HKLM\SYSTEM\CurrentControlSet\services\AFSService\AutoStartDelay Set decimal value to 240. (The default is 120).
Windows Registry Disclaimer:
Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 “Description of the Microsoft Windows registry” at Microsoft Support.