YOUR DEVELOPERS COMPLAIN THAT THEY CAN’T CONNECT TO THE SERVER USI...

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.