You are the database administrator of your company. You install a SQL Server 2008 computer on the network.You want to ensure that the SQL Server service is able to interact with other network services. What is the recommended type of account that you should configure for this purpose?
A.
a Network Service account
B.
a local user account
C.
a Local Service account
D.
a domain user account
Explanation:
You should configure a domain user account for the SQL Server service. To ensure that services installed onSQL Server function properly, each service must be associated with a user account. You can configure SQLServer services to use built-in system accounts or domain user accounts. A domain user account isrecommended when the SQL Server service must interact with network services or access network resources,such as shared folders on file servers. Using a domain user account is also recommended if the SQL Serverservice uses linked server connections to other SQL Server computers. You should not configure a Network Service account for SQL Server. The Network Service account can also beused to achieve the objective stated in this scenario, but using a Network Service account is not recommendedbecause it is a shareable account. You should not configure a local user account or a Local Service account for SQL Server. The Local Serviceaccount is one of the built-in accounts in Windows. This account has the same privileges as members of the Users group. The services that use the Local Service account do not use credentials to access networkresources. The Local Service account cannot be configured for the SQL Server and the SQL Server Agentservices. A Local Service account or a local user account that does not have administrator privileges isrecommended if the server is not a member of the domain, such as a server installed on the perimeter network, orif the service does not require access to network resources.
Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure SQL Server services.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started Initial Installation > Planning a SQL ServerInstallation > Setting Up Windows Service Accounts TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started > Initial Installation > Planning a SQL ServerInstallation > Setting Up Windows Service Accounts