A Powershell Script that automates all the needed configurations in order to get the SQL Server Linked Server Passwords. ... The first step is enabling TCP/IP connections on all SQL Server Instances.

I try to add a connection to an Azure Sql Server with Encrypt setting set to Strict. Generally, adding the connection works. However, it seems the encrypt setting is set back to "Mandatory" all the ...