Windows – Local service accounts

user-accountswindows-services

Normally we create service accounts in Active Directory, and if we install things like SQL Server, etc, we set services to use those service accounts. The service accounts don't have the ability to be used to log into a workstation interactively.

For Proof of concept, we're installing SQL Server and other software on Virtual windows 7 workstations that aren't part of a domain, so we are creating local accounts that will be used by windows services. Is it possible to stop those users from appearing as options on the login screen?

Best Answer

Another option would be to use virtual accounts. New to Windows 7 and Windows Server 2008 R2, services can run as a virtual service account that doesn't exist as a user on the machine and cannot be used interactively.

To run a service using a virtual account, the logon user should be set to "NT SERVICE\{servicename}" (the password can be left blank). For example, SQL Server Express' virtual account might be called "NT SERVICE\MSSQL$SQLEXPRESS"

This would give two benefits:

  1. Eliminate the need to manage passwords for the service accounts (virtual accounts can only be used by Windows Services; they cannot be used to gain remote access to the computer or log on interactively).
  2. The users will not appear on the logon screen.

If a service accesses the network while running as a virtual account, it accesses resources as the computer account (DOMAIN\Computername$). But, since these computers aren't joined to a domain, this shouldn't be an issue anyway.

I learned of virtual accounts from this blog post that gives a quick overview of virtual accounts (and managed service accounts).

Related Question