I have to convert over 50 servers to use encrypted connections. Is there a way to set Force Encryption and Trust Server Certificate with a script of some kind (Powershell, etc.)?
John Deupree
dbatools can help: https://www.powershellgallery.com/packages/dbatools/0.9.20/Content/functions%5CEnable-DbaForceNetworkEncryption.ps1
However. If this is a one time thing, I would guess you can click through config manager 50 times much quicker than writing a script, testing it, and verifying it works. The development and testing of scripts can be complex. I might start with dbatools with a couple instances and see if I can set everything I need.
February 17, 2025 at 9:02 am
Anyone else thought exactly as Steve did (do it manually better than testing a script), but thought again when the "force encryption" was cleared? Can't work out how it happened, but perhaps by a windows update or a policy update?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply