PSS ID Number: 250550
Article Last Modified on 7/15/2004
The information in this article applies to:
- Microsoft SQL Server 7.0
This article was previously published under Q250550
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
SUMMARY
You may sometimes want to change the default network library a client computer uses to communicate with SQL Server. The usual procedure to do this is to use the Client Network Utility to change this setting. However, in some instances, you cannot install this utility. In these cases, you can modify the registry manually to select the default library.
NOTE: This procedure is not recommended. The correct way to change the default network library is by using the utilities provided by SQL Server.
MORE INFORMATION
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To change the default network library, go to the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
and add a value of type string named DSQUERY. You can change the network library using the values in the following list:
- TCP/IP: DBMSSOCN
- Named Pipes: DBNMPNTW
- Multiprotocol (RPC): DBMSRPCN
- NWLink IPX/SPX: DBMSSPXN
- AppleTalk: DBMSADSN
- Banyan VINES: DBMSVINN
REFERENCES
For further information on the Client Network Utility, please see the following MSDN article
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
137635 INF: ODBC SQL Server Connection Parameters
Additional query words: SQL Server TCP/IP Netlib Network Client configure protocol
Keywords: kbConfig kbhowto kbnetwork KB250550
Technology: kbAudDeveloper kbSQLServ700 kbSQLServSearch