asp.net core migration

Try to modify your Existing Connection string 

"Server=IT\SQLEXPRESS; Database=TESTDB; User Id=sa; Password=sa@123; TrustServerCertificate=True"

I faced the same issue in my previous solution.

https://rijsat.com/2022/12/12/entity-framework-update-database-error-the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted/

The default value of the Encrypt connection setting has been changed from false to true. With the growing use of cloud databases and the need to ensure those connections are secure, it’s time for this backwards-compatibility-breaking change.

We need to add additional parameters trusted_connection=true;encrypt=false; in the connection string.

"ConnectionStrings": {
    "AppDatabase": "Data Source=rijwan7475001;Initial Catalog=mydotnet7;Integrated Security=True;trusted_connection=true;encrypt=false;"
  }

Hi Tahir plz updated your Connection String as below-

"ConnectionStrings": { "SqlServerConnection": "Server=.; Database=MyDb; User ID=MyUser; Password=MyPwd; Trust Server Certificate=true;" }

This is happening due to the SSL certificate presented by the server is not trusted by the client. Modify your db connection string as

"Server=YourServerAddress; Database=YourDBName; User Id=YourDBUserID; Password=YourDBPassword; TrustServerCertificate=True"

Hello Tahir,

Just add TrustServerCertificate=Yes;  end of your connection string in appSettings.json file

"ConnectionStrings": {
    "SqlServerConnection": "Server=.; Database=YourDatabaseName; User ID=YourUserName; Password=YourPassword; TrustServerCertificate = true;"
  }

Hello Tahir,

This error message is indicating that the SSL certificate used by the server you're trying to connect to is not trusted by the client you're using to connect.

Use below connection string and check.

Data Source=Your_server_address;Initial Catalog=Your_DB_name;Persist Security Info=True;User ID=user;Password=password;Encrypt=True;TrustServerCertificate=True

Thanks

Naimish 

Modify your connection string as

"Server=YourServerAddress; Database=YourDBName; User Id=YourDBUserID; Password=YourDBPassword; TrustServerCertificate=True"

Hi,

In Asp.Net Core connection string you can add "Trust Server Certificate=true;".

 "ConnectionStrings": {
    "SqlServerConnection": "Server=.; Database=MyDb; User ID=MyUser; Password=MyPwd; Trust Server Certificate=true;"
  }

Please check the following reference :

https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn/17658821#17658821

Hi Tahir,

This error occurs when the server's SSL certificate is not trusted by the client.

For testing purposes, disable SSL validation in your ASP.NET Core application temporarily but not recommended for production environments as it introduces security risks.