sql server error 10054 an existing connection was forcibly closed by the remote host

SQL Server Error : 10054 Details

SQL Server Error: 10054 Severity: 16 Event Logged or not: No Description: The data value for one or more columns overflowed the type used by the provider. Severity 16 Description: Indicates general errors that can be corrected by the user.

A service instance’s service principal name (SPN) is a unique identifier. Kerberos authentication uses SPNs to link a service instance to a service logon account. In summary, an SPN mapping associates a service on a given server with an account responsible for its maintenance, allowing mutual Kerberos authentication.

“an existing connection was forcibly closed by the remote host sql … Read the rest