How does SQL server 2012 still work after changing the Service account to a domain account or even a local account. For example: as mentioned in MSDN
Instid\MSSQL\data has full control privileges to the virtual account
NT service\MSSQLSERVER. But I am confused how SQL server still starts after changing the service account to a domain or local account as this new service account will not be having privileges to this particular folder unless we explicitly provide it. And from what I tested, SQL Server fails to start if you remove
NT service\MSSQLSERVER from
Instid\MSSQL\data folder's permissions.
So does this mean any account which is a SQL server service account is automatically added to
NT service\MSSQLSERVER group?, How does this work?