The Transact-SQL® global variable @@ssl_ciphersuite allows users to know which cipher suite was chosen by the SSL handshake and verify that an SSL or a non-SSL connection was established.
Adaptive Server sets @@ssl_ciphersuite when the SSL handshake completes. The value is either NULL, indicating a non-SSL connection, or a string containing the name of the cipher suite chosen by the SSL handshake.
For example, an isql connection using SSL protocol displays the cipher suite chosen for it.
1> select @@ssl_ciphersuite 2> go
Output:
------------------------------ TLS_RSA_WITH_AES_128_CBC_SHA (1 row affected)
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
