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.
Bạn đang xem 3. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P143 PPTX