YOUR SECURITY ADMINISTRATOR HAS DETERMINED THAT ALL THE SQL SERVERS...

4. Your security administrator has determined that all the SQL Servers in your

organization need to listen on nondefault TCP ports, and she doesn’t want

network users to see the SQL Servers in a browse list. Which two actions

would achieve this goal?

A. Stop and disable the browser service on each SQL Server

B. Use Configuration Manager on each server to change each instance to

listen on port 50000

C. Use Configuration Manager on each server to change each instance to

listen different ports

D. Configure the SQL Browser Service to hide each instance

E. Enable Show Advanced Options using sp_configure and use the

Default TCP port option to configure the port for each instance

Correct Answer & Explanation: A and C. Stopping the browser service will

stop all instances on that server being browsable. Configuration Manager

is the only place you can change the TCP port for an instance. Each instance

on a server must listen on a unique port. Answers & Incorrect Answers &

Explanations: B, D, E. Answer B is incorrect because configuring each instance

with the same port on the same server will prevent all but one instance from

working. Answer D is incorrect because you cannot hide an instance using the

SQL Browser Service. Answer E is incorrect because Configuration Manager is

the only place you can change the TCP port for an instance.