You administer a Microsoft SQL Server 2012 default instance.
The instance is hosted by a server that has a localfirewall 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 youdo? 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 theWindows Firewall on the server.
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms191464.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms190468.aspx
The answer is D,C
No, the correct answer is A,B,C.
sp_configure ‘remote access’, 1 enables the stored process remote access, not the DAC.
DAC connection requires port 1434 open hence you need to configure the firewall.
Well B,C and for sure as for A it depends.
“There’s always a catch. You many need to get firewall ports opened as well, depending on your environment and where you intend to connect from. This will probably be port 1434, but that will vary depending on your configuration.”
http://www.brentozar.com/archive/2011/08/dedicated-admin-connection-why-want-when-need-how-tell-whos-using/
USUALLY the DAC Port is 1434.
“By default, the DAC only listens on the loop-back IP address (127.0.0.1), port 1434. If TCP port 1434 is not available, a TCP port is dynamically assigned when the Database Engine starts up. When more than one instance of SQL Server is installed on a computer, check the error log for the TCP port number.”
https://msdn.microsoft.com/en-us/library/ms190468.aspx
forgot to mention since this question did not mention that the DAC port is dynamically configured you can assume that the default port is 1434. Hence A,B,C is the most correct.
It cannot be A, the question states Instance configuration not Server configuration.
?
i guess the answer should be ABC,
because the question said “You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections.”
the emphasis is “EVEN IF THE SQLSERVER IS UNRESPONSIVE TO CLIENT CONNECTIONS”, client can’t connection to server,so we just can use DAC to connection SQLSERVER,
so we should configure ‘remote admin connections’,the answer is ABC.