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.
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.
Explanation:
http://msdn.microsoft.com/en-us/library/ms191464.aspx
http://msdn.microsoft.com/en-us/library/ms190468.aspx
Based to https://technet.microsoft.com/en-us/library/dd450973.aspx the answer is:
ADC
A-D-C
Guys, A-B-C
Remote admin connection allows to access to the server even when it’s unresponasble to any client connections…
Vakum is right according to the second link in the explanation
I second vakum. Remote Access allows normal Client Connections to the Server.
Plus:
. The remote access option controls the execution of stored procedures from local or remote servers on which instances of SQL Server are running. This default value for this option is 1. This grants permission to run local stored procedures from remote servers or remote stored procedures from the local server. To prevent local stored procedures from being run from a remote server or remote stored procedures from being run on the local server, set the option to 0.
So the option is D is not needed.
Option B should be: sp_configure ‘remote admin connections’, 1
But that is the closest one, besides AC