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
Option B is wrong option; Options A, B, D are the right options.
To configure “remote access” you do the following:
1. In SSMS: In Object Explorer => right-click server-name => select Properties =>
Click the Connections node => Under Remote server connections, select the ‘Allow remote connections to this server check box’.
2. Using T-SQL:
USE AdventureWorks2012;
GO
EXEC sp_configure ‘remote access’, 1;
GO
RECONFIGURE;
GO
You mean A C D?
With this article you should be right: https://technet.microsoft.com/en-us/magazine/dd450973.aspx
ACD!
Sorry, I meant ACD. That’s what I selected in my exams, and I missed just a few questions overall.
BUT WHEN THE COMMAND IN THE EXAM IS LIKE THIS:
sp_configure ‘remote admin connections’, 1
This source is convincing me to answer it like this: ABC
http://www.madeiradata.com/dedicated-administrator-connection/
It describes exactly the problem in this question
I agree with JosefTheGreat, the question specifically states You need to ensure that the instance is configured to allow remote connections even if the SQL Server is
unresponsive to client connections. I feel ABC is the correct choice given the wording here.
If the configure syntax is written out as follows:
sp_configure ‘remote admin connections’, 1
Then, that would be a valid choice for allowing ‘remote administrative access’, even when client connections are denied.
I am wondering why it is 1434 port in A not 1433?