Understanding Client-Server Configuration

Before you begin setting up a network with specific values, you should be familiar with this general configuration information:

• To accept requests from clients and servers, servers use "Listen On" values that specify a network type and a process identifier. The server accepts requests that are directed to that process identifier. An Open Data Services server application can listen on multiple network types and process identifiers simultaneously.
• To enable communication with a particular server, clients and servers use "Connect To" values that specify a network type, a node identifier, and a process identifier for each server.
• Remote server information for SQL Server is entered via two SQL Server stored procedures, sp_addserver and sp_configure. Note that when you identify an Open Data Services server application as a remote server, you use the same procedure that you use when identifying another SQL Server as a remote server. For more information, see the Microsoft SQL Server Administrator's Companion.
• The server names you choose are case-sensitive for some types of clients and servers on the network.

Not all computers on your network are necessarily of the same network type. SQL Server and Open Data Services allow you to use mixed networks.

For more information about configuring Open Data Services clients and using the SQL Client Configuration Utility, see Microsoft SQL Server Setup.