Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/250550

From BetaArchive Wiki
Knowledge Base


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


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