You are installing a new SQL Server instance on a machine in a small network. You have only one SQL Server on the network and you want to make administration as simple as possible. Which service account type should you use?

You are installing a new SQL Server instance on a machine in a small network. You have only one SQL Server on the network and you want to make administration as simple as possible. Which service account type should you use?

You are installing a new SQL Server instance on a machine in a small network. You have only one SQL Server on the network and you want to make administration as simple as possible. Which service account type should you use?


Answer – Built-in system account

(The built-in system account is the easiest to maintain because you do not need to control the password for it (in fact, you can’t). Also, you do not need to communicate with other servers over the network, so a domain account is unnecessary.)