EF Core: A connection was successfully established with the server, but then an error occurred during the login process happening spontaneously

0

I have issues with our SQL Server express install on the staging environment. The following exception happens in spontaneous intervals and it requires the .NET Core app to be restarted to fix the issue.

Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - Success)

Locally the issue never happens, I have tried the following things to fix the issue but to no avail.

  • Use SQL Server Developer Version
  • Migrate the SQL Server instance to its own Droplet
  • Run the SQL Server instance in Docker next to the app using the instance.

Did anyone face the issue before and find a fix for it?

.net
sql-server
entity-framework-core

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0