I have a Windows Internal Database installation running with its default settings. I have the required "Logon as a service" permissions configured as follows:
Administrators
ALL SERVICES
LOCAL SERVICE
NETWORK SERVICE
NT SERVICE
After the first server restart since SQL installation the service fails to start. I add an entry for NT SERVICE\ALL SERVICES
in the service logon permissions and everything works again. The thing I don't quite grasp is that why wouldn't NT SERVICE\ALL SERVICES
be already included either with NT SERVICE
or ALL SERVICES
entry?
Technically the service is configured to logon with NT SERVICE\MSSQL$MICROSOFT##WID
so there is backslash after NT SERVICE
but I don't think that would be the actual root cause here.