管道运行期间间歇性Azure SQL登录失败 [英] Intermittent Azure SQL login failures during pipeline runs

问题描述

由于Azure SQL数据库登录失败，我们开始出现间歇性管道故障（下面的错误）。  Azure SQL数据库的链接服务使用托管身份连接到美国中南部地区的资源。  

We've started to get intermittent pipeline failures due to login failures to Azure SQL database (error below).  The linked servic for the Azure SQL database uses Managed Identity to connect to resource in South Central US region.  

无法连接到SQL Server：XXXX消息=用户登录失败'NT AUTHORITY \\ ANONYMOUS LOGON'。，Source = .Net SqlClient Data Provider，SqlErrorNumber = 18456，Class = 14，ErrorCode = -2146232060，State = 1，Errors = [{Class = 14，Number = 18456，State = 1，Message = Login
for user'; NT AUTHORITY \\ANONYMOUS登录'';'

使用相同的链接服务，一个具有多个复制活动的较大管道成功，但由于上述错误而在管道中进一步失败。 两个预定的管道使用相同的链接服务立即失败并且上面的错误，但是当手动触发时，
成功执行。

One larger pipeline with multiple Copy activities is successful using the same linked service, but fails further down the pipeline with the error above.  Two scheduled pipelines fail immediately using the same linked service with the error above but execute successfully when triggering manually.

推荐答案

很抱歉知道哪些问题面对，因为你没有提到任何时间表，我们无法检查在特定时间是否有任何持续的问题。我们可以建议，由于这是一个间歇性问题，请设置重试
选项，并设置足够的间隔时间，如果有帮助，请告诉我们。 

Sorry to know about the issues which are facing ,since you have not mentioned any timeline we don't have any way to check if there was any ongoing issue at a particular time . We could suggest that since this is an intermittent issues , please set the retry option with adequate inter-interval and let us know if that helps . 

这篇关于管道运行期间间歇性Azure SQL登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！