18. Your developers complain that they can’t connect to the server using SQL
Server Management Studio. You’ve used Terminal Services to log on to the
server, and you’ve confirmed that TCP/IP is enabled. You now want to test it
with a local connection. What should you do?
A. Nothing, just connect
B. Disable Shared Memory in Configuration Manager
C. Move TCP/IP above Shared Memory in the connection protocol order
D. Disable Shared Memory using sp_configure ‘shared memory enabled’
Correct Answer & Explanation: B. Disabling Shared Memory will force SQL
Server to use the next protocol to connect which is TCP/IP by default.
Incorrect Answers & Explanations: A,C, D. Answer A is incorrect; local
connections will use the Shared Memory protocol by default. Answer C is
incorrect because Shared Memory cannot be moved in the connection
protocol order, only disabled. Answer D is incorrect because the sp_configure
option is invalid.
Bạn đang xem 18. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P145 PPSX