Tuesday, August 19, 2008

Changing SQL Server Network Connetivity Protocol priority using registry

Without using the SQL network client tools or SQL server client tool, to changed the client pc sql network protocol you can use the below to register. This registry will add a Protocol order and set the "tcp np" as the values. That's means the tcp will be priority over the name pipes.


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib]
"ProtocolOrder"=hex(7):74,00,63,00,70,00,00,00,6e,00,70,00,00,00,00,00
"Encrypt"=dword:00000000