You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing B. AIOTestKing B runs a single SQL Server instance. You manage AIOTestKing B from an administrative workstation named DBA1. AIOTestKing B intermittently fails to respond to user queries. Currently, it is not responding to your connection through SQL Server Management Studio. You need to correct the problem. What should you do?
A.
Log on interactively to AIOTestKing B as an administrator. Establish a dedicated administrator connection to the SQL Server instance.
B.
Log on to AIOTestKing B by using the Administrator logon account that is built into Microsoft Windows.
C.
Log on to the SQL Server instance on AIOTestKing B by using the sa logon account that is built into SQL Server.
D.
Restart the SQL Server Browser on AIOTestKing B.
Explanation:
SQL Server 2005 provides a special diagnostic connection for administrators when standard connections to the server are not possible. It allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests. This dedicated administrator connection (DAC) is available and supported through the command-line interface, sqlcmd, using a special administrator switch (-A).