Sample Header Ad - 728x90

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 . enter image description here 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