Configuring SQL Server service accounts
An important part of the configuration of your SQL Server environment is the service accounts that are used for running your SQL Server services. Many of these can be configured immediately during the installation of your SQL Server. There are several options for you to select from while configuring an account for SQL Server services, as follows:
- Virtual accounts
- Managed service accounts
- Group managed service accounts
- Built-in system accounts
- Domain user accounts
- Local Windows accounts
Let's now get into each of the accounts in detail.
Virtual accounts
The default choice of any OS higher than Windows Server 2008 R2 is a virtual account. A virtual account is a managed local account for the simple administration of your services. One of the important benefits of virtual accounts is their auto management, so you don't need to worry about regular password updates on...