Which service enables a client to connect to the SQL Server instance over a network?
A)loopback
B)listener
C)SQLCMD
D)shared memory

Question

Quizplus · Accepted Answer

A listener is responsible for enabling clients to connect to a SQL Server instance over a network, by listening for incoming connection requests and routing them to the appropriate SQL Server instance. The other options are not relevant in this case: The loopback address (A) refers to the IP address 127.0.0.1, which is used to refer to the local computer itself; shared memory (D) is a type of inter-process communication mechanism that enables different processes to share memory segments directly, which is not used for network communication; SQLCMD (C) is a command-line utility for running SQL statements, but does not have a direct role in enabling network connectivity.

Which Service Enables a Client to Connect to the SQL