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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy