I upgraded to Hangfire 1.6.8 and now get the following errors connecting to a SQL Azure database:
“A connection was successfully established with the server,
but then an error occurred during the pre-login handshake.
(provider: SSL Provider, error: 0 - The wait operation timed out.)”
“The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=333; handshake=165;”
I have tried changing the TrustServerCertificate property in the connection string to true and also followed all the recommended solutions for this error (i.e. checking winsock, performing a winsock reset etc - http://stackoverflow.com/questions/12082077/handshake-exception-occurring-when-connecting-to-sql-server-azure-with-net-4-5).
Downgrading to Hangfire 1.6.7 seems to fix this issue. Is this a bug or is it a configuration issue?