• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1359
  • Last Modified:

Using Wireshark to Detect an Encrypted SQL Server 2000 connection

Is it possible to verify if a SQL Server is using an Encrypted connection with Wireshark?

If so, how?

I can see the actual sql statement with Wireshark but I can not see if the SQL connection is encrypted.

0
FastEddie___
Asked:
FastEddie___
1 Solution
 
Matt VCommented:
If you can see the SQL statements then the connection is not encrypted.
0
 
torque_200bcCommented:
can you post the wireshark output?
0
 
FastEddie___Author Commented:
I have attached the wireshark .pcap file and an image that shows the query being run.
Please let me know what you think.
 

WireShark-Results.GIF
Bitstream-Capture.txt
0
SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

 
Matt VCommented:
As I said, if you can see the plain text then the stream is not encrypted.
0
 
FastEddie___Author Commented:
Thank you.

0
 
Dave HoweSoftware and Hardware EngineerCommented:
encrypted sql is over tls - so if it starts with a https-style handshake, it is working :)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now