Forum Discussion

rmerritt's avatar
rmerritt
Copper Contributor
Jun 10, 2024

Moved auth db from localdb to mssql now I get a cert error

here is the error

 

SqlException: 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.)

 

I did an export in ssms from localdb to the new sql databasse then changed the default connection

 

 

 

 

 

3 Replies

  • Hi,
    I imagine you found the solution but just in case ... I had the same problem and needed to add this "TrustServerCertificate=true;" to my connection string.
    • Abhishek_Khatri's avatar
      Abhishek_Khatri
      Brass Contributor
      Yes issue exactly is that and it is resolved by adding this TrustServerCertificate=true into connection string.

Resources