how to set in-transit encryption sql server?
2
votes
1
answer
1167
views
today I had to check if in-transit Encryption was up and running in a particular server (sql server) and if not then set it up.
the way it is done is:
> In SQL Server Configuration Manager, expand SQL Server Network
> Configuration, right-click Protocols for , and then
> select Properties. On the Flags tab, in the ForceEncryption box,
> select Yes, and then select OK to close the dialog box. Restart the
> SQL Server service.
the picture below is after I restarted the sql server service .
now, I am one DBA that likes DBA paradise, and all automation and things done through scripts.
How could I get this done through scripts? partial solutions also valid.
and it could be powershell,T-SQL, or any other scripting language.

Asked by Marcello Miorelli
(17274 rep)
Jun 27, 2024, 02:31 PM
Last activity: Jul 1, 2024, 11:28 AM
Last activity: Jul 1, 2024, 11:28 AM