Domain.com has a server named SQL1 that is dedicated to SQL Server 2005. SQL1 is configured for SQL Server and Windows Authentication mode. Using Windows Authentication, you have sysadmin privileges on SQL1. All users who work with SQL1 report that all applications that use SQL1 stop responding. Your supervisor asks you to investigate the problem. In Task Manager, you notice that CPU usage is at 100 percent. You try to connect to SQL1 by using SQL Server Management Studio. SQL1 does not respond. You need to connect to SQL1 to diagnose the problem. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Connect to SQL1 by using the osql command-line utility.
B.
Connect to SQL1 by using the sqlcmd command-line utility using a dedicated administrator connection.
C.
Connect to SQL1 by using SQL Server Management Studio. Open a query window and execute the following command.DBCC TRACEON 1224
D.
In SQL Server Management Studio, on the toolbar, click Database Engine Query to open the Connect to Database dialog box. In the Server name text box, type ADMIN:SQL1. Select SQL Server Authentication and provide your sa credentials. Click the Connect button.
Explanation:
The DAC is implemented as a specific TCP endpoint in a SQL Server instance that is always attached to a dedicated UMS. The DAC was created to provide a connection that could always be used by a member of the sysadmin role to access a SQL Server instance, thereby guaranteeing that an administrator could no be locked out of SQL Server due to resource allocation issues. You can connect to the DAC in two ways: either via SQLCMD or through the query window in SSMS.