Post reply

What TLS version is used: how?

  • February 4, 2021 at 4:01 pm

    #3841018

    Hello,

    Is there a way to find the TLS-version used in connections on SQL Server 2019?

    I'm getting The event name, "sqlsni.trace", is invalid, or the object could not be found

    when I try to add extended event sqlsni.trace

    CREATE EVENT SESSION [tls] ON SERVER

    ADD EVENT sqlsni.trace(

        WHERE ([sqlserver].[like_i_sql_unicode_string]([text],N'%Handshake%')))

    https://www.sqltact.com/2018/01/sql-server-on-tls-12-xevent-session-to.html

  • February 4, 2021 at 4:09 pm

    #3841024

    Solved: On SQL2019 it's called sqlsni.sni_trace instead of sqlsni.trace

  • February 4, 2021 at 4:36 pm

    #3841047

    sqlsni.trace seems to be removed in CU8 probably for fix 13671396 XEvent sqlsni.sni_trace does not fire unless sqlsni.trace is enabled in SQL Server 2019.

    Thanks to stummsft for a helper function

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply