SQL 2005 SP1 - Enable encryption between server and client

Certifications

RSS

Last web search to here

office communicator 2007 R2 breaks winrm
imagex.exe gui
constant credentials prompts with exchange server 2007 SP1
ATi driver will not install on windows 7
Cisco VPN Client 5.0.4.0300
itunes xp x64
span rdp
DNE citrix
WIndows 2003 iso
how to add emoticons in office communicator

Wednesday, April 19. 2006

SQL 2005 SP1 - Enable encryption between server and client

Looks like the one of the new features mentioned in the SP1 release notes is located here:

"A registry switch has been added that you can use to control encryption between a master server and a target server (MSX-TSX)."

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1

It looks like it is a DWORD toggle of 0 or 1 with the setting of 'Value' determining whether or not to use encryption between the SQL server agent and SQL server.

Posted by Aaron Tiensivu in SQL at 15:58 | Comments (0) | Trackbacks (0)

3285 hits