Intermittent Azure SQL login failures during pipeline runs RRS feed

  • Question

  • 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.  

    Cannot connect to SQL Server: XXXX Message=Login failed for user '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 failed for user ';NT AUTHORITY\\ANONYMOUS LOGON'';'

    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.

    Thursday, May 9, 2019 4:17 PM

All replies

  • 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 . 

    Thanks Himanshu

    Friday, May 10, 2019 6:47 PM