Câu 79: 70-764: Administering a SQL Database Infrastructure
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 allows 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 conn…
Nội dung câu hỏi
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 allows 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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server. — đáp án hiện tại
- B. Execute the following Transact-SQL command: sp_configure 'remote admin connections', — đáp án hiện tại
- C. Execute the Reconfigure command. — đáp án hiện tại
- 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.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.