Problem
A customer recently reported that they tried to build a SQL Server running on Windows Server 2022 but found that the SQL Server Agent failed to start. Below is the error popup when starting the SQL Server Agent in SQL Server Configuration Manager.
There are no other errors in ERRORLOG, SQLAGENT, and Windows event logs.
We worked with the customer and collected TTD (Time Travel Debugging) traces on several services. Finally, we found out the cause of the problem.
In Windows, there is a group policy named “Configure log access” under “Computer Configuration” -> “Administrative