Sophos Management Service fails to start when server is rebooted, however it starts fine when done manually.
First seen in
Enterprise Console 4.0.0
The SQL Server service takes too long to start, resulting in a timeout when the Sophos Management Service attempts to start. This is most commonly associated with under-powered servers.
What To Do
As a workaround to the performance issues, a dependency for the local SQL Server (Sophos) instance can be created under the Sophos Management Service.
Note: The program should be run from a command prompt. If you have User Account Control (UAC) enabled and are not logged on as the Administrator account you will see the error: The requested operation requires elevation when attempting to run the program. Either:
- Elevate the command prompt.
- Log on as the Administrator account (not an account which is just a member of the Administrators group) as this is account is not affected by UAC.
- Temporarily disable UAC (requires a reboot).
- Select Start | Run | Type:
cmd.exe | Press return.
- Run the command:
sc config "Sophos Management Service" depend= rpcss/mssql$sophos
This can also be done manually by modifying the service registry key:
- Click Start | Run and type
- Browse to:
HKEY_LOCAL_MACHINE|SYSTEM|CurrentControlSet|Services|Sophos Management Service
- Modify the 'DependOnService' value adding
MSSQL$SOPHOS to the next line.