The SQL Server Agent is a dependency service. Even if you set it to Automatic startup it could end in failure and does not start automatically. If you manually start it will work. Try making the startup type as “ Automatic (Delayed Start) “ and it works.