Wireshark is cool - but in this case MNM is 'better'.-Network monitoring signifies to the practice of managing the procedure of a computer network using specified management software tools. So far - regarding MSSQL-Traffic - or to be more precice TDS-Protocol this is the best tool I've come across so far. Means it can understand the TDS-Protocoll fully.Īlso with an extension (so called experts) 'NmDecrypt' and the right certificates (including private keys) - it is possible to decrypt protocolls - quite nice for TDS which uses TLS INSIDE of TDS - no wonder - no one has really implemented that yet as a fully supported protocoll for wireshark ) Nonetheless wireshark as mentioned above would be sufficient to validate encryption and applied certificates on the wire itself. The MNM can even visualize the resultsets going over the wire - quite neat. This is also true for sql server connections.

The tool is quite old and looks abandoned (havn't seen a newer release so far) but still does an good job and the grammar for defining new protocols is quite neat/interesting - so this still possess a lot of power for the future.Īnalysis Example - Recording is filtered for TDS - so the other packets are discared mostly: Basically this is very similar to wireshark with the exception that some specific MS protocols have better parser and visualisation support than wireshark itself and obviously it would only run under windows -). There is another much underrated tool from Microsoft itself: 'Microsoft Network Monitor'. Note: Microsoft Message Analyzer was deprecated in late 2019, and is no longer available for download.

See also comment below this answer or the answer further down for how to use it! Edit (): Microsoft Network Monitor - has been replaced by Microsoft Message Analyzer - which serves the same purpose.

Wireshark tzsp