Configuring agent with service account
The Microsoft SQL Server agent supports multiple service account types for running the agent. This procedure is specifically for MS SQL Server agent on Windows OS.
Before you begin
MS SQL Server agent is certified with following service account types as a service startup account:
- Local Windows User
- Domain User
- Virtual Service Account
- Managed Service Account
- Group Managed Service Account
About this task
For more information about these account types please refer official Microsoft
documentation:https://docs.microsoft.com/en-us/windows/security/identity-protection/access-control/service-accounts
Note: For
Virtual Service Account, MSA and gMSA accounts the agent is certified in the 8.1.4.0.16
release.
Procedure
What to do next
For user account to be able to collect data, make sure user has required permissions in the operating system as mentioned in Running as a non-administrator user
If you want to use Windows authentication in SQL Agent, then make sure that user has the required permissions in SQL Server as mentioned in Creating a user and granting permissions.