We are using SQL Server 2016 and want to use the Force Encryption option. From what I read, is it just installing the certificate on the Server itself and then setting the ForceEncyption to "Yes"? Is there anything needed on the client side like updating the connection string that it uses to connect? Or does setting the ForceEncryption take care of it?
Sorry, I'm new to encryption and we want to implement that on our SQL servers and it seems straight forward but I'm getting conflicting instructions as to whether the data connection string needs to be modified or not. We are also using AAG as well so will implementation be different as well?