- The "Domain User account" is used when the "service must interact with network services"
- "Local Service account" has "same level of access to resources and objects as members of the Users group"
- "Network Service account" is same as local service account, but the network services can be accesed using the credentials of users group.
- "Local System account" is a highly privileged account and must be used with caution!!
The services that are to be started at end of installation can be choosen in this screen itself.
The next screen allows the "Authentication Mode" to be choosen.If the server is to be on a network with all systems having a Windows domain account, the Windows authentication mode can be choosen, else the Mixed mode has to be selected and a password has to be specified for "sa" logon.The colation settings define the sorting behaviour for the server and are rather important.
Generally the colaltion settings are of utmost importance when upgrading from a previous version of SQL server.