Activity overview
Latest activity by arick111
manishkumar said:
Hello, We are defining a new naming convention for the versioned scripts in our team. E.g. earlier it was V1.1.1__xx, now we want to make it V2023.01.17.xx Is it possible to just rename the SQL scripts that are already deployed? Thanks!
No, renaming already deployed SQL scripts could cause issues. It's best to create new scripts with the updated naming convention / comments
manishkumar said:
Hello,We are defining a new naming convention for the versioned scripts in our team. E.g. earlier it was V1.1.1__xx, now we want to make it V2023.01.17.xxIs it possible to j...
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. / comments
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 str...