A connection was successfully established with the server, but then an error occurred during the login process Error from .Net core WebAPI

Amit Potdar 131 Reputation points
2021-12-14T12:23:52.077+00:00

Hi,

I've an application that uses WebAPI in .Net core 6 and uses Kestrel server. When calling HttpPost request, the code tries to inject data in DB but fails with error:

The certificate chain was issued by an authority that is not trusted.

Inner exception: A connection was successfully established with the server, but then an error occurred during the login process

The obvious resolution is to inject TrustServerCertificate=True in the connection string. But this is a security risk as it can trust invalid certificate.

I'm using Dapper package to communicate with Sql server database.

After investigation, I found that this happens when I refer Microsoft.Data.SqlClient package. If I replace with System.Data.SqlClient package, above error occurs no more and I don't have to inject TrustServerCertificate flag.

1) Can anyone let me know why this error is raised when I refer Microsoft.Data.SqlClient?
2) Which package (System.Data.SqlClient or Microsoft.Data.SqlClient) is recommended for the new development (i.e. .Net 6 and Kestrel)

Thanks,
Amit

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,166 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,716 questions

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. kosmos 246 Reputation points
    2022-10-12T14:38:57.963+00:00

    Hi,
    The proposed solutions did not work for me. Any ideas ?249755-untitled.png

    Please see screenshot.

    I am trying to connect to a Synapse SQL Dedicated Pool with visual code studio

    0 comments
  2. Francisco Javier Martínez Sánchez 1 Reputation point
    2022-11-08T10:53:32.82+00:00

    I has the same problem, with this solution !now work!. Thanks

    0 comments
  3. Aaron Obed Giron Garrido 0 Reputation points
    2023-07-05T20:32:57.5733333+00:00

    Hello

    I have a problem when I try to generate the dbContext classes in ASP .NET Core Web API, I try many solutions, but I have not succeeded yet, does anyone know any guide to help me solve it.

  4. John Sonron 0 Reputation points
    2023-08-29T12:32:31.01+00:00

    I am facing a similar situation on my Business IT Solutions website server. If the Web API is accessed from a different domain, ensure that CORS settings are configured to allow requests from the client application's domain.

    0 comments
  5. Bala Murugan Velusamy 1 Reputation point
    2023-12-19T09:50:44.0166667+00:00

    This Connection string works well. you check your connection string similar to following example

    Example: 1
    Server=YourSystemName\SQLEXPRESS;Database=YourDb;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True

    Example: 2
    Server=YourSqlInstance;Database=YourDb;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True

    Example: 3 (if in appsettings.json use double slash "\")
    Server=YourSystemName\SQLEXPRESS;Database=YourDb;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True

    0 comments