Hangfire Error `Connection string is missing for the SQL error log

Question

I am busy trying to add hangfire to my MVC project. I am following the Quick Start Guide

I have added this to my startup.cs file

   public void Configuration(IAppBuilder app)
    {
        ConfigureAuth(app);          

        //Hangfire
        GlobalConfiguration.Configuration.UseSqlServerStorage("data source=ip;initial catalog=Name;user id=Hangfire;password=Password;");
        app.UseHangfireDashboard();
        app.UseHangfireServer();
    }

However when I run my project I get the following error: (it highlights the GlobalConfiguration.Configuration.UseSqlServerStorage line in my startup.cs class)

Connection string is missing for the SQL error log.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Elmah.ApplicationException: Connection string is missing for the SQL error log.

Perhaps the error message is misleading and it's just not a valid connection string. Often a connection string also has a provider in it. Just a guess — Nick.Mc
– Nick.Mc, Commented Jun 7, 2017 at 6:42

Sujith · Accepted Answer · 2017-06-09 00:57:45Z

1

I believe you have your current logger as Elmah and Hangfire trying to pickup the Elmah logging to log the execution process of Hangfire jobs. If you look at the Elmah config and check if you have anything like <logger name="*" minlevel="Trace" writeTo="network" /> - here instead of * you can specify your application's Elmah logger name, so that Hangfire cannot use this. This solution is to avoid Hangfire logging to your application related log.

However if you wish to fix the issue you are facing, check the ELmah config and see if the required connection string is properly set.

edited Jun 9, 2017 at 0:57

answered Jun 8, 2017 at 2:30

Sujith

1,8141 gold badge10 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zapnologica · Accepted Answer · 2017-06-07 11:01:46Z

0

It turns out the error message had nothing to do with hangfire. I simply did not have a connection string for Elmah in the web config.

answered Jun 7, 2017 at 11:01

Zapnologica

22.6k44 gold badges175 silver badges260 bronze badges

3 Comments

Sujith Over a year ago

I think you have found solution by yourself.. great !!

Nick.Mc Over a year ago

Thanks for returning with a solution. It seems the hangfire doco must be incorrect when it says you can put a connection string in here directly. Do you mind posting both the final code and web.config that worked for you?

Sujith Over a year ago

In case you have not seen this link : blog.elmah.io/elmah-tutorial It might help you.

Collectives™ on Stack Overflow

Hangfire Error `Connection string is missing for the SQL error log

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related