1

I have to update 50+ servers to use encrypted connection strings. Is there a way to script setting Force Encryption and TrustServerCertificate (e.g Powershell, or ???) so that I don't have to open Configuration Manager and set on each box?

John Deupree
  • 13
  • 2

1 Answers1

0

Yes use dbatools in particular the command Enable-DbaForceNetworkEncryption

Stephen Morris - Mo64
  • 4,656
  • 1
  • 10
  • 18