The Multiprotocol selection has two key features:
- Automatic selection of an available network protocol to communicate with an instance of Microsoft® SQL Server™.
This is convenient when you want to connect to multiple servers running different network protocols but do not want to reconfigure the client connection for each server. If the client and server Net-Libraries for TCP/IP Sockets, NWLink IPX/SPX, or Named Pipes are installed on the client and server, the Multiprotocol Net-Library will automatically choose the first available network protocol to establish a connection.
- Client encryption.
You can enforce encryption over the Multiprotocol Net-Library on clients running on the Microsoft Windows NT® 4.0, Windows® 2000, Windows 95, or Windows 98 operating system to prevent others from intercepting and viewing sensitive data.
The Multiprotocol Net-Library takes advantage of the remote procedure call (RPC) facility of Windows NT 4.0 and Windows 2000, which provides Windows Authentication. For the Multiprotocol Net-Library, clients determine the server address using the server name.
Before using the Multiprotocol Net-Library, consider the following:
- The Multiprotocol Net-Library does not support named instances of SQL Server 2000. You can use the Multiprotocol Net-Library to connect to the default instance of SQL Server on a computer, but you cannot connect to any named instances.
- The Multiprotocol Net-Library does not support server enumeration. From applications that can list servers by calling dbserverenum, you cannot identify servers running an instance of SQL Server and listening on the Multiprotocol Net-Library.
Multiprotocol Name Resolution
Using the RPC run time, which is called by the Multiprotocol Net-Library, clients can connect to servers using a variety of other protocols. When establishing a connection, the Multiprotocol Net-Library passes the computer name to the RPC run time, which determines the available network protocols and attempts to use each one until a connection is established. Only NWLink IPX/SPX, TCP/IP Sockets, and Named Pipes are tested and supported.
To accomplish the computer name to node connection, the RPC run time uses a naming service compatible with the network protocol used (WINS for TCP/IP, SAP for NWLink IPX/SPX, and Net BIOS broadcasts for Named Pipes). Only the computer name should be specified, because a local RPC database is used to resolve the names over the supported protocols.
You can enforce encryption over the Multiprotocol Net-Library on a per-client basis. Only this client's communications are encrypted. Other clients using the Multiprotocol Net-Library that do not have this parameter set do not use encryption.
To configure a client to use the Multiprotocol Net-Library