Microsoftwe are using the shared central management server feature, and using SSMS 20 with the encryption set to mandatory as a default, we are not able to "connect" to the group without manually setting the encryption property to "Optional" and saving each connection. Where is this connection information saved?
Our system manages the central list of serves using the sp_sysmanagement_add_shared_server_group, and sp_sysmanagement_add_shared_registered_server stored procedures, each night removing all servers and rebuilding the list from meta-data. Is there a way to set the encryption setting for each connection "centrally" without requiring each developer to manually update each connection, every day??
ah, i see this:
https://feedback.azure.com/d365community/idea/27452b60-0af8-ee11-a1ff-00224827349c
if MS had decided to default to "Optional" instead of "Mandatory", until they had a solution for storing the setting in the central management connection, this would be a smoother transition. we'll just revert back to 19.
