You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005 with the default settings. The Domain.com network contains a database server named Certkiller -DB01 that hosts a database named CK_Sales. The CK_Sales database stores sales data for the company. One morning Domain.com users complain that they are unable to connect to Certkiller -DB01. You log on to your client computer named Certkiller -WS444. You attempt to connect to Certkiller -DB01 using the Dedicated Administrator Connection (DAC) but the connection fails. You need to be able to connect to Certkiller -DB01 from Certkiller -WS444.
What should you do? (Each correct answer presents part of the solution. Choose two.)
A.
Start the SQL Server Agent service on Certkiller -DB01.
B.
Start the SQL Browser service on Certkiller -DB01.
C.
Run the sp_configure ‘remote admin connections’, 0; statement on Certkiller -DB01.
D.
Enable the remote admin connection option on Certkiller -DB01.
E.
Enable named pipes on Certkiller -DB01.
Explanation:
By default, only local dedicated administration connections (DACs) are allowed as DAC only listens on the loop-back IP address (127.0.0.1). You need to enable the remote admin connection option on Certkiller -DB01 by running the sp_configure ‘remote admin connections’, 1; statement. You should also start the SQL Browser service on Certkiller -DB01 as the SQL Server client uses this service to determine the port number that DAC is listening on. Alternatively, you can configure DAC to use a specific port.
Incorrect Answers:
B: The Dedicated Administrator Connection (DAC) does not require the SQL Server Agent service.
C: The sp_configure ‘remote admin connections’, 0; statement allows SQL Server to accept only local dedicated administration connections (DACs) using port 1434 on the loop-back IP address (127.0.0.1). This is the default setting.
E: The Dedicated Administrator Connection (DAC) uses TCP/IP and does not require named pipes.