Category: Hangfire.Processing.BackgroundExecution --- System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'ABC'


I have a question about the implementation hangfire with .net core web api. Firstly, I got a success implementation on my computer it was work, after that I try to send api and hangfire on web server. I got an error like that;

Category: Hangfire.Processing.BackgroundExecution
EventId: 0

Execution BackgroundServerProcess is still in the Failed state for 00:00:30.0352717 due to an exception, will be retried no more than in 00:00:15

System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘ABC’.
at System.Data.SqlClient.SqlInternalConnectionTds…ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)

Is there any solutions about that ?

This has been reported as a glitch from Hangfire, the best way to solve:
Create your database before you start the application.

1 Like