Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message.

For testing purposes I would like to have the login credentials sent in clear text. The password would still be hashed which is fine, but my network admin wants to be able to pick up the other login details in a trace file.

I’ve been told that there is some way to disable the encryption for the connection handshake in some cases for some applications, but I don’t have any details about how to do this or when it can be applied.

share|improve this question
From what I understand so far: SQL 2000 - Credentials could be encrypted, but may not always be if encryption is not enabled. SQL 2005/8 - Credentials are guaranteed to be encrypted. A verified certificate will be used if available, if not then a self signed certificate will be generated. – KiwiNige Aug 12 '10 at 2:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.