We are very excited to announce a significant “refresh” to the current Azure SQL Database Elastic Jobs preview! This refresh brings several new capabilities that were highly requested by our customer...
Updated Nov 27, 2023
Version 3.0
Blog Post
I'm using Entra authentication and it generally works fine. However, I sporadically get the error, 'Failed to connect to the target database: Login failed for user '<job_credential>'.' The issue appears to arise randomly, and I've been unable to find the cause. As a workaround, I've found that scaling up the Elastic Job Agent (and then scaling it back down to my preferred tier), without making any other configuration changes, resolves the problem. Could this be a problem with how the Elastic Job Agent handles Entra authentication, or might I be missing something in my configuration?