Database Reference
In-Depth Information
21. On the Server Configuration page under the Service Accounts tab, specify the
login account name and password for SQL Server Analysis services and SQL
Server Browser.
22. You can assign the same login account to all SQL Server services, or you can
configure each service account individually.
It is recommended that you configure the service accounts individually to
provide least privileges for each service, where SQL Server services are
granted the minimum permissions they have to complete their tasks.
23. This account must be a Windows domain user account. Built-in machine accounts
(such as Network Service or Local Service) are prohibited.
24. SQL Server Setup enforces the domain user account requirement by blocking
installation whenever a machine account is specified.
25. Next, use the Server Configuration page under the Collation tab to specify non-
default collations for the Database Engine and Analysis Services.
26. At the database engine configuration | Account provisioning page, we have the
option to set the security mode and assign an account to be a member of
SYSADMIN
fixed server role.
Search WWH ::
Custom Search