0

I played around with a new SQL Server 2019 Developer and noticed something strange. I enabled Perform volume maintenance tasks during installation and setup the engine to use a domain account, but after installation the service account is not visible in Local Security Policies. I checked using the below query and also in the log, and it looks ok.

Any idea why the service account is not showing up in Local policies?

select instant_file_initialization_enabled ,* 
from sys.dm_server_services
where servicename like 'SQL Server%'

enter image description here

1 Answer 1

1

Any idea why the service account is not showing up in Local policies?

It uses the per service sid, when you change the account it'll still work. You can see this in your screenshot.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.