March 12, 2018 at 11:25 am
All:
I have a request from our security group to provide a list of all databases encrypted at rest or in Transit. I can identify databases with TDE easily by running SELECT name FROM SYS.DATABASES WHERE is_encrypted = 1 in CMS.
As for in Transit, I know I can log into a server, open SQL Configuration Manager follow these instructions:
https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx
But is there a query to run in CMS or PowerShell so I don't have to log into each server?
Dan
March 12, 2018 at 11:30 am
dan-572483 - Monday, March 12, 2018 11:25 AMAll:I have a request from our security group to provide a list of all databases encrypted at rest or in Transit. I can identify databases with TDE easily by running SELECT name FROM SYS.DATABASES WHERE is_encrypted = 1 in CMS.
As for in Transit, I know I can log into a server, open SQL Configuration Manager follow these instructions:
https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspxBut is there a query to run in CMS or PowerShell so I don't have to log into each server?
Dan
this information will be in the registry you could get it from there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2018 at 2:00 pm
I see I can also SELECT * from sys.dm_exec_connenctions where encrypt_option = 'TRUE' and join it to sysprocesses to get the database names.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply