HOTSPOT
A user is attempting to connect to a secure remote Microsoft SQL database on a computer running
Windows 7 Professional. The computer communicates on port 1433. A rule in Windows Firewall with
Advanced Security allows communication. The user cannot connect to the database on the currently
defined protocol due to an error in protocol type. You need to ensure that users can connect to the database.
Which setting should you choose? (To answer, select the appropriate setting in the work area.)

Answer:

Explanation:
If a computer is running Microsoft SQL database, then firewall must permit communication through
TCP port 1433. Therefore, change the protocol type from UDP to TCP.
To open a port in the Windows firewall for TCP access
On the Start menu, click Run, type firewall.cpl and then click OK.
In the Windows Firewall dialog box, click the Exceptions tab, and then click Add Port.
In the Add a Port dialog box, in the Name text box, type SQL Server <instance name>.
In the Port number text box, type the port number of the instance of the Database Engine, such as
1433 for the default instance.
Verify that TCP is selected, and then click OK.