I have upgraded SQL Server 2008 R2 Express to SQL Server Standard Edition. After I have upgraded it, the SQL Server Agent was stopped.
I have tried to start but it fails.
Only when I have changed his built in account from "Network Service" to "Local System" it started.
Looking at MSDN How to: Upgrade to a Different Edition of SQL Server 2008 R2 Procedure 13 it says:
Provision the SQL Server Agent service account by using SQL Server Configuration Manager
- What does it mean provision it?
- What built in account should the SQL Server Agent run with?