SSL Connections and Dynamic Management Views

External Since: Dec 03, 2008 Posts: 1

If I'm setting up SSL encryption for my connections to a SQL Server and I'm
forcing it from the client side (optional from the server side), is there
some dynamic management view that I can use to see which sessions are using
SSL encryption and which are not?

External Since: Jan 15, 2007 Posts: 80

Check out the encrypt_option column of sys.dm_exec_connections
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Charles Hawkins" <charles.hawkins DeleteThis @jenzabr.net> wrote in message
news:OigcaecVJHA.3740@TK2MSFTNGP06.phx.gbl...
> If I'm setting up SSL encryption for my connections to a SQL Server and
> I'm forcing it from the client side (optional from the server side), is
> there some dynamic management view that I can use to see which sessions
> are using SSL encryption and which are not?
>