You can use below scripts to find out if any sql server is using SSL certificate
SELECT session_id,
encrypt_option,*
FROM sys.dm_exec_connections
select * from sys.dm_exec_connections
where encrypt_option =
'TRUE'
Both above scripts let u find out if SSL certificate is used or not.
If yes, the get the session_ID and check which application is being used.
sp_wHO2'ACTIVE'
DBCC INPUTBUFFER(51)
No comments:
Post a Comment