Multi-protocol encryption

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply