Keyword not supported: 'trust server certificate'.
chuck
Posts: 29 Bronze 2
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
-
chuck Posts: 29 Bronze 2Just in case someone else encounter the same problemTrust Server Certificate=True changed to TrustServerCertificate=TrueMulti Subnet Failover=False changed to MultiSubnetFailover=FalseRemove the space in key will solve the problem
-
chuck Posts: 29 Bronze 2The 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.
Answers