You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance hosts quite a few applications. ABC also has a server
named ABC-SR43 that is used to store log files.
You have to set up a new job that stores log files on ABC-SR43. You create a new account
ABC\Log_Account. You set it up to be run by the SQL Server Agent Services.
However, your job fails to store any log files on ABC-SR43. After some investigation you notice
that the job does not have permissions to store files on ABC-SR43.
How should you remedy the situation? Select the best option.
A.
You should set up ABC\Log_Accoun as a Remote Service account.
B.
You should set up ABC\Log_Accoun as a Domain service account.
C.
You should set up ABC\Log_Accoun as a Local Service account.
D.
You should set up ABC\Log_Accoun as a Local System account.
E.
You should set up ABC\Log_Accoun as a Network Service account.
F.
You should set up ABC\Log_Account as a Domain account.
Explanation:
The service startup account defines the Microsoft Windows account in which SQL Server Agent
runs and its network permissions. SQL Server Agent runs as a specified user account. For
compatibility with earlier versions of SQL Server, SQL Server Agent can also run as the Local
System account.
In this scenario you should select a Domain account, which allows sufficient permissions and
improved security.