You are installing a new SQL Server 2008 instance on a machine in a small peer-to-peer network. You will not be performing replication so SQL Server will not need to communicate with other severs over the network. You need to be able to change the service account’s password every six months per company policy. Which service account type should you use?
Answer – Local system account
(You can’t use a domain account because there is no domain, and you can’t change the password for the built-in system account, so the only choice here is a local system account.)