YOU HAVE A DEFAULT INSTANCE AND A NAMED INSTANCE INSTALLED ON YOUR...

3. You have a default instance and a named instance installed on your server. The

developers are complaining that they can’t connect to the named instance from

their workstations using Management Studio anymore. You log on to the

server through Terminal Services and can connect to each instance without

issue. What could the cause of this behavior be?

A. The developers haven’t created a SQL Server Alias to the named instance

using the Shared Memory protocol.

B. The SQL Browser Service has been started.

C. The SQL Browser Service has been stopped.

D. The IP addresses of the developers’ workstations have been added to the

Exclude list in the TCP/IP properties of the named instance in

Configuration Manager.

Correct Answer & Explanation: C. By default, named instances used dynamic

TCP port allocation, and clients depend on the SQL Browser Service to find

the current port. Incorrect Answers & Explanations: A, B, D. Answer A is

incorrect because you can’t create an alias that uses the Shared Memory

protocol, and it can be used only by tools running on the server. Answer B is

incorrect because the SQL Browser Service being started helps remote

connections to named instances. Answer D is incorrect because you cannot

exclude IP addresses from connecting to SQL Server using Configuration

Manager.