HOWTO: Change SQL Server Default Network Library Without Using Client Network Utility

ID: Q250550

The information in this article applies to:

Microsoft SQL Server version 7.0

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

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: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

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

Using the SQL Server Client Network Utility

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

Q137635 INF: ODBC SQL Server Connection Parameters

Additional query words: SQL Server TCP/IP Netlib Network Client configure protocol

Keywords : kbnetwork kbConfig kbMTS kbSQLServ700 kbDSupport
Version : winnt:7.0
Platform : winnt
Issue type : kbhowto