Configuring User and Remote Connections
Requests for data are handled through user connections to client systems. The client opens a connection to SQL Server, makes a request, and waits for a response from SQL Server. When the client is finished with its request, it closes the connection. Other servers and applications can also connect to SQL Server remotely. To configure client connections and remote server connections, you can use the Connections page in the Server Properties dialog box.
Many settings are associated with client and server connections, as you can see in Figure 6-5, which shows the default configuration. This section examines connection settings and cases in which you might want to change these settings.
Figure 6-5. The default ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
