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.

FastEddie___Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Matt VConnect With a Mentor Commented:
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
Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.