sql server - Azure data factory copy activity fails. Login failed for user -
we trying copy data on prem sql server azure blob storage through data factory copy activity.
- installed data management gateway , connect.
- build copy pipeline copy table azure blob, ran fine week
we seeing error since 2 days now
copy activity encountered user error @ source side: errorcode=usererrorfailedtoconnecttosqlserver,'type=microsoft.datatransfer.common.shared.hybriddeliveryexception,message=cannot connect sql server: '', database: '', user: ''.,source=microsoft.datatransfer.clientlibrary,''type=system.data.sqlclient.sqlexception,message=login failed user 'chinese char displayed here'.,source=.net sqlclient data provider,sqlerrornumber=18456,class=14,errorcode=-2146232060,state=1,errors=[{class=14,number=18456,state=1,message=login failed user 'chinese char displayed here'.,},],'.
client able login sql server same credentials given in data management gateway. checked status of management gateway , fine , ran diagnostic check of connection management gateway
refer step 8 thru 12 of microsoft documentation in order ensure active certificate , connection azure data factory. next, view logs in diagnostics tab further assess issue outside of data factory. lastly, ensure on-prem linked service in adf correctly deployed. if destination linked service utilizing sastoken, ensure date follow:
{ "name": "storagesaslinkedservice", "properties": { "type": "azurestoragesas", "typeproperties": { "sasuri": "<storageuri>?<sastoken>" } } }
hope helps.
Comments
Post a Comment