Our production pipelines are failing due to shared error and need your assistance further.

Question

Our production pipelines are failing due to shared error and need your assistance further.

Murli Kunagu (Tata Consultancy Services Limited) 20 Microsoft External Staff

Error

Copy User data to SQL_copy1

Troubleshoot activity failures

{ "errorCode": "2200", "message": "ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'AZCUMPHRPSQL25', Database: 'Workspace', User: 'redmond\hcsd'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.,Source=.Net SqlClient Data Provider,SqlErrorNumber=18452,Class=14,ErrorCode=-2146232060,State=1,Errors=[{Class=14,Number=18452,State=1,Message=Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.,},],'", "failureType": "UserError", "target": "Copy User data to SQL_copy1", "details": [] }

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hi @Murli Kunagu (Tata Consultancy Services Limited)
Thankyou for reaching microsoft Q&A!
Based on the information provided, we understand that the customer has already tried the necessary steps. However, the issue persists because the pipeline is still attempting to use Windows authentication with the redmond\hcsd account.

We understand that the account was migrated from the Redmond domain to Microsoft Entra ID, and the account password expired on 21 June 2026. As a result, the authentication is failing with Error 18452 (untrusted domain).

We recommend engaging the SQL Server/Identity team to verify the authentication configuration and update the Azure Data Factory linked service to use the appropriate Microsoft Entra ID authentication method, if applicable.