PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unres

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.

PrepAway - Latest Free Exam Questions & Answers

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

2 Comments on “You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unres


Leave a Reply