You work as a database administrator at ABC.com.ABC.com contains a server, named ABCDB01, which has SQL Server 2008 R2 installed and includes multiple instances of SQL Server
2008 R2.
These multiple instances of SQL Server2008 R2 should be able to link up to the dedicated
administrative link as part of ABC.com’s disaster recovery strategy. During testing you are able to
hook up to the link on ABC-DB01’s default instance, but you are unable to hook up to the
dedicated link on the other two instances.
You have received the following instructions:
•Make sure that the instances are executing.
•Make sure that the client applications can approach the instances.
•Prevent other administrators from hooking up to any dedicated links on ABC-DB01.
•Ensure that you are able to hook up to the dedicated link on all of the instances.
Which of the following actions should you take?
A.
You should consider making use of the SQL Server Web service and configuring it to activate
automatically.
B.
You should consider making use of the Distributed Transaction Coordinator service and
configuring it to activate automatically.
C.
You should consider making use of the SQL Server Reporting service and configuring it to
activate automatically.
D.
You should consider making use of the SQL Server Browser service and configuring it to
activate automatically.
Explanation: