 Tutorial published by: John, on 2006-03-16
Purpose
The purpose of this article is to teach you the process of configuring a client to use the Multiprotocol Network Library using Client Network Utility in Microsoft SQL Server 2000.
To Configure a Client to Use the Multiprotocol Net-Library
The Multiprotocol Net-Library uses the Windows 2000/2003 an NT remote procedure call (RPC) facility. In addition, the Multiprotocol Net-Library:
- Communicates over most IPC mechanisms supported by Windows NT. Only TCP/IP Sockets, NWLink IPX/SPX, and Named Pipes are considered tested and supported.
- Allows the use of Windows Authentication over all protocols that RPC supports.
- Supports encryption for user password authentication as well as data.
- Offers performance comparable to native IPC Net-Libraries for most applications.
Note: Before creating a Multiprotocol client configuration, make sure your computer has at least one IPC protocol loaded under Multiprotocol on the server (Named Pipes, NWLink IPX/SPX, TCP/IP, or Windows Sockets).
Following steps describe you the step by step details of configuring a client to use the Multiprotocol Net-Library:
1. Click Start, go to Programs. then go to Microsoft SQL Server, and click Client Network Utility.
2. Click Alias tab.
3. Click Add button.
4. Now, enter the alias for i.e. MyServer Server alias, and select the Multiprotocol under Network Libraries, and then click OK.
5. Now, click Apply, and then click OK.
| 
Lab Practices & Notes
Study Guides
Discussions
News
Downloads & Links
Contents
Users Information
Misc
