Multi-protocol encryption

• rambo

  SSC Eights!

  Points: 879

  More actions

  February 6, 2002 at 7:13 pm

  #157551

  Dear Listers,

  I have recently seen a similar question put to another Forum, however I did not

  note any replies. Perhaps I missed them.

  After the multi-protocol encryption has been configured, SQL Server relies

  on Windows NT RPC to use 40-bit RC4 encryption.

  My questions are:

  By what means can one :

  Verify that encryption is actually functioning?

  Interrogate the string being passed from the server?

  TIA

  John

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  February 6, 2002 at 8:57 pm

  #423375

  Probably one of the easiest ways is by using NetMon or some similar network sniffer package. NetMon and Sniffer Pro can both understand and translate TDS packets (Tabular Data Stream - What Sybase and SQL Server both use to communicate between client and server). Typically though there are a lot of special characters in a TDS packet, but you can see the data going back and forth with respect to character fields and queries. If the transmission, you shouldn't be able to decipher any of it with the naked eye.

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley