You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A runs three instances of SQL Server. Your company’s disaster recovery plan includes having the ability to connect to the dedicated administrative connection on each instance of SQL Server. While testing this ability, you discover that you can connect to the dedicated administrative connection on AIOTestKing As default instance. But you cannot connect to the dedicated administrative connection on the two other instances on AIOTestKingA. You verify that the instances are running and that client applications are able to access them. You also verify that the dedicated administrative connection is enabled for all instances. You confirm that no other administrators are attempting to connect to any dedicated administrative connections on AIOTestKingA. You need to ensure that you can connect to the dedicated administrative connection on all three instances. What should you do?
A.
Start the SQL Server Browser service. Configure the service to start automatically.
B.
Reconfigure the default instance to use an administrative port number other than 1434.
C.
Use the Sqlcmd.exe tool to make the dedicated administrative connection.
D.
Stop and restart the non-default instances of SQL Server.
Explanation:
The DAC port is assigned dynamically by SQL Server during startup.
When connecting to the default instance, the DAC avoids using a SQL Server Resolution Protocol (SSRP) request to the SQL Server Browser Service when connecting. It first connects over TCP port 1434. If that fails, it makes an SSRP call to get the port. If SQL Server Browser is not listening for SSRP requests, the connection request returns an error.