SQL Server agent collector process not restarted automatically

Body

In ITCAM for Microsoft Applications, the  SQL Server agent process that performs data collection, called koqcoll, has been provided with a
feature to automatically recover in case of troubles, for example if it realizes it cannot login to the target DB, if mandatory
cursors are not returning data or after unexpected Network errors.

This is done by invoking koqresat.cmd script.  
Anyway there is a specific condition where this will not occur.
If the agent is configured to start with a non-administrator account, in case of problems the koqcoll process will not be  
able to restart automatically.  
The restart is performed by script koqresat.cmd, that executes net stop/net start of the collector service.  
In Windows, net stop/net start command can be invoked only by accounts having admin privileges.  
Otherwise it fails with "Access is denied" message.
You can try this by running a net start from command line for any service when logged in with a non-administrator account.

So when we configure the agent to run with a non-administrator account, it will not be able to run "net start" and the  
collector will not be restarted in case it fails.

This is also confirmed by looking at the messages written into file "koqresat.log" when the collector tries to perform the restart:

<<logs>>  
System error 5 has occurred.  
Access is denied.  
System error 5 has occurred.  
Access is denied.  
<<logs>>  

There is no way to avoid it.
In case of problems, restart the service manually or implement an external solution that automatically restart the collector  
service in case it goes down.  

A DOC APAR has been opened about this: IJ05886.
It is intended to be used by L3 to update the SQL Server Agent manual and document this limitation.
They anyway confirmed they are already evaluating possible alternatives to implement service restart also when the service account has no admin privileges.

Thanks for reading.

Subscribe and follow us for all the latest information directly on your social feeds: