Microsoft KB Archive/250550

= How To Change SQL Server Default Network Library Without Using Client Network Utility =

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

