You administer a Microsoft SQL Server 2016 default instance. The instance is hosted by a server that has a local firewall configured.

The firewall only all

ows inbound connections on port 1433. The server only hosts a single instance of SQL Server.

You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections.

What should you do

?

A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.

B. Execute the following Transact-SQL command: sp_configure remote admin connections,

C. Execute the Reconfigure command.

D. Execute the following Transact-SQL

command: sp_configure remote access, 1

E. Restart the SQL Server Agent Service.

F. Enable inbound connections on TCP port 135 in the Windows Firewall on the server.

SQL Server provides a dedicated administrator connection (DAC). The DAC

lets an administrator access a running server to execute diagnostic functions or Transact-SQL statements, or to troubleshoot problems on the server, even when the server is locked or running in an abnormal state and not responding to a SQL Server Database

Engine connection. By default, the DAC is only available from a client on the server. To enable client applications on remote computers to use the DAC, use the remote admin connections option of sp_configure.

By default, the DAC only listens on the loop-b

ack IP address (127.0.0.1), port 1434

The following example enables the DAC from a remote computer.

sp_configure remote admin connections, 1;

GO

RECONFIGURE;

GO

References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/

remote-admin-connections-server-configuration-option