I am using a single SQL Server express 2019 on a standalone systems which is in workgroup (no Active Directory).

In this case is it a good practice to use default virtual accounts (as shown in the image) instead of creating local user accounts?

What is the best practice for setting up sql service accounts when the system is in workgroup?

Is there any security risk with virtual accounts vs using local accounts?

​I am using a single SQL Server express 2019 on a standalone systems which is in workgroup (no Active Directory). In this case is it a good practice to use default virtual accounts (as shown in the image) instead of creating local user accounts? What is the best practice for setting up sql service accounts when the system is in workgroup?Is there any security risk with virtual accounts vs using local accounts?   Read More

​