asp.net core migration

Question

i'm facing issue

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

Sachin Singh · Answer

Modify your connection string as "Server=YourServerAddress; Database=YourDBName; User Id=YourDBUserID; Password=YourDBPassword; TrustServerCertificate=True"

Jignesh Kumar · Answer

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;" }

Naimish Makwana · Answer

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

Rajeesh Menoth · Answer

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

Rijwan Ansari · Answer

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;" }

Anupam Maiti · Answer

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 "

Muhammad Imran Ansari · Answer

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.

Rajeev Kumar · Answer

Hi Tahir plz updated your Connection String as below- "ConnectionStrings": { "SqlServerConnection": "Server=.; Database=MyDb; User ID=MyUser; Password=MyPwd; Trust Server Certificate=true;" }

Anandu G Nath · Answer

Try to modify your Existing Connection string "Server=IT\SQLEXPRESS; Database=TESTDB; User Id=sa; Password=sa@123; TrustServerCertificate=True"