What should you do to prevent blockage of the port used to communicate with a SQL Server instance?
A)disable the firewall on the client
B)configure a fixed port
C)disable the firewall on the server
D)use named pipes

Question

Quizplus · Accepted Answer

Configuring a fixed port for SQL Server instance will prevent blockage of the port used to communicate with the server. This way, the port will always be available for communication and will not be blocked by the firewall or other factors. Disabling the firewall on the server or client is not recommended as this could compromise the security of the system. Using named pipes is also an option, but configuring a fixed port is more reliable.

What Should You Do to Prevent Blockage of the Port