Microsoft
70-458 · Question #140
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the windows NT Service virtual accounts…
The correct answer is D. Configure the Subscriber to use a Windows domain account. See the full explanation below for the reasoning.
Question
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the windows NT Service virtual accounts for all SQL Services. You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber. The distribution agent on ProdSrv2 regularly fails, displaying the following error message: "Cannot access the file. Operating system error code 5 (Access is denied.)." You need to configure the distribution agent by granting only the minimum required access to all accounts. What should you do?
Options
- AConfigure the SQL Server Agent service to run under the Local System account.
- BConfigure the SQL Server Agent service to run under a Windows domain account.
- CConfigure the Subscriber to use the Local System account.
- DConfigure the Subscriber to use a Windows domain account.
How the community answered
(45 responses)- A7% (3)
- B2% (1)
- C11% (5)
- D80% (36)
Community Discussion
No community discussion yet for this question.