How is SQL Change Automation helping you? Share to win DevOps books.

Keyword not supported: 'trust server certificate'.

Working on version 4.2.20168, and encounter error Keyword not supported: 'trust server certificate'.
remove Trust Server Certificate=True, then got error Invalid connection string: Keyword not supported: 'multi subnet failover'.
remove Multi Subnet Failover=False, then got Error connecting to database: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

According https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn, I add Trust Server Certificate=True to the end of ShadowConnectionString section and make it work.

  <ShadowConnectionString>Data Source=ip;Initial Catalog=Chuck2_Connect5;User ID=clu;Password=;Pooling=False;Encrypt=False;Trust Server Certificate=True;Authentication=SqlPassword;Multi Subnet Failover=False</ShadowConnectionString>
changed to
 <ShadowConnectionString>Data Source=ip;Initial Catalog=Chuck2_Connect5;User ID=clu;Password=;Pooling=False;Encrypt=False;Authentication=SqlPassword;TrustServerCertificate=True</ShadowConnectionString>








Best Answers

  • chuckchuck Posts: 29 Bronze 2
    edited July 20, 2020 10:03AM Accepted Answer
    Just in case someone else encounter the same problem
    Trust Server Certificate=True changed to TrustServerCertificate=True
    Multi Subnet Failover=False changed to MultiSubnetFailover=False
    Remove the space in key will solve the problem




  • chuckchuck Posts: 29 Bronze 2
    Accepted Answer
    The problem was  introduced in 4.2.20176 - June 24th, 2020.
    I previously use 4.2.20168 open the old project created by 4.2.20176.







Sign In or Register to comment.