Multiple choice technology databases

When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?

  1. An error will occur

  2. Data passed between the client and the server is encrypted.

  3. User IDs and passwords are passed to the server unencrypted

  4. User IDs and passwords are encrypted before they are passed to the server.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When a client requests SERVER_ENCRYPT authentication, the server must support password encryption. If the server is configured with SERVER authentication, it only accepts unencrypted credentials. Attempting this connection results in a security negotiation mismatch error.

Keep practicing — related questions