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 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
    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.







Answers

  • arick111arick111 Posts: 2 New member
    chuck said:
    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>








    The user encountered errors when connecting to a database with version 4.2.20168. They resolved the issue by adjusting the connection string and adding Trust Server Certificate=True to the end of the ShadowConnectionString section. This change allowed them to successfully establish a connection to the database.


  • I just wanted to let you know in case anyone else encounters the same issue
    Added TrustServerCertificate=True to TrustServer Certificate=True
    Fault over to multiple subnets = False changed to Fault over to multiple subnets = False
    Eliminating the space in the key will fix the issue.
Sign In or Register to comment.