Can anyone help me on below :
I would like change the SQL Service \ SQL Agent Service to Active Directory Accounts . But before that I would like to understand below :
Can I use the default accounts which SQL Service provides by default
- Local Service
- Local System
- Network Service
If I cannot why I cannot use them ?
If I can then why should I need Windows Domain Level Service Accounts ?
Why SQL Server Agent Account needs to be added as SysAdmin , is it by default nature of SQL Server Agent Account ?
Can anyone please help me with the background of the above points in brief .