A connection was successfully established with the server but then an error during login process

A connection was successfully established with the server …

For SQL2008,. open Management Studio; Rt click on instance; go to properties; select Security; Under Server Authentication, check SQL Server …

A connection was successfully established with the server …

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

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

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

[Fix] A connection was successfully established with the server …

[Fix] A connection was successfully established with the server, but then an error occurred during the login process – Never Too Old To Learn

Jul 9, 2019 — The reason for this common error is that by default MS SQL Server runs in “Windows Authentication mode”. And you will need to change it to “SQL …

SQL connection error: A connection was successfully established with the server, but then an error occurred during the login process. No process is on the other end of the pipe.

A connection was successfully established with the server …

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. · Issue #1479 · dotnet/SqlClient · GitHub

Jan 18, 2022 — A connection was successfully established with the server, but then an error occurred during the pre-login handshake. #1479.

Describe the bug After I update the Microsoft.Data.SqlClient from 3.0.1 to 4.0.1 when I try to access the database I’m getting Exception message: Stack trace: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfu…

A connection was successfully established with the server …

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the… – CodeProject

Mar 28, 2012 — SQL Server Configuration Manager > SQL server Network Configuration > Protocols for MSSQLSERVER(choose the server you want to create the user).

Free source code and tutorials for Software developers and Architects.; Updated: 15 Feb 2021

Solved: Microsoft SQL: A connection was successfully estab…

Solved: Microsoft SQL: A connection was successfully estab… – Microsoft Power BI Community

… el siguiente problema: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process.

Solved: Estimados usuarios, he recurrido al foro porque creo que estoy en un problema que para mi es bastante grande, el dia de hoy intente ingresar

Can no longer connect to server (an error occurred during …

windows – Can no longer connect to server (an error occurred during the pre-login handshake) – Server Fault

Could be that you are trying to connect with an encrypted connection and the servers certificate is not trusted anymore (or just expired).

A connection was successfully established with the server, but …

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider | Chanmingman’s Blog

Jan 2, 2023 — A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider.

This blog article shows you one of the ways to resolve the error “A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider”. I have connection string as follows. It used to work fine till the latest operating system update. string connectionString = “Data Source=172.23.64.1;Initial…

A connection was successfully established with the server …

A connection was successfully established with the server, but then an error occurred during the login process – Tero Marine Support

This error message (A connection was successfully established with the server, but then an error occurred during the login process) is most likely related …

This error message (A connection was successfully established with theserver, but then an error occ…