SQL server agent無法啟動

Question

原本是EXPRESS版本

但購買了標準版的序號升級上去

要用維護計劃時發現

要啟用SQL server agent卻無法無法啟動

顯示

登入帳號也是都無法啟動

Answer 1

Hi **william,
**Thanks for sharing the details. Could you please try the troubleshooting steps below

1. Repair the Installation
   • Open SQL Server Installation Center → Maintenance → Repair.
   • This re-registers SQL Server Agent components that weren’t activated during the upgrade.
2. Check SQL Server Configuration Manager
   • Go to SQL Server Services.
   • Confirm SQL Server Agent (MSSQLSERVER) is listed.
   • Set Start Mode = Automatic.
   • Try starting the service manually.
3. Configure the Service Account
   • Open Services.msc → SQL Server Agent → Properties → Log On tab.
   • Use a domain account or Local System with “Log on as a service” rights.
   • Avoid using BUILTIN\Users (security risk).
4. Verify Event Log Access
   • On Windows Server 2022, SQL Server Agent must write to the Application Event Log.
   • Ensure the Agent service account has permission to write logs (Group Policy → Event Log Service → Application → Configure log access).
5. Check TLS Registry (if applicable)
   • Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client
   • Set DisabledByDefault=0 and Enabled=1 for both Client and Server.

Thanks,

Lakshmi.