Sql Server. Set connection network library in registry. Author Nigel Rivett

home

-- Sql Server. Set connection network library in registry.
Author Nigel Rivett

This enables you to set the defaukt connection library without installing client utilities.

From
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q250550&

To change the default network library, go to the following registry key: 
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
add a value of type string named DSQUERY.

Change the library by using the following values

TCP/IP:			DBMSSOCN
Named Pipes:		DBNMPNTW
Multiprotocol (RPC): 	DBMSRPCN
NWLink IPX/SPX: 	DBMSSPXN
AppleTalk: 		DBMSADSN
Banyan VINES: 		DBMSVINN

home