Microsoft
70-457 · Question #160
You administer a Microsoft SQL Server 2012 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…
The correct answer is A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server. B. Execute the following Transact-SQL command: C. Execute the Reconfigure command. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 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? Choose all that apply.
Options
- AEnable inbound connections on TCP port 1434 in the Windows Firewall on the server.
- BExecute the following Transact-SQL command:
- CExecute the Reconfigure command.
- DExecute the following Transact-SQL command:
- ERestart the SQL Server Agent Service.
- FEnable inbound connections on TCP port 135 in the Windows Firewall on the server.
How the community answered
(48 responses)- A75% (36)
- D8% (4)
- E13% (6)
- F4% (2)
Community Discussion
No community discussion yet for this question.