Error Code: 18456 DFExecutorUserError Error Message: Login failed for user '<token-identified principal>

Maria Giugno 76 Reputation points
2022-03-22T20:30:09.44+00:00

I am receiving an access error when trying to run my data flow.

I have been trying to clear this error for 2 days. Any help is appreciated!

Error codeDFExecutorUserError
Troubleshooting guide
Activity ID8739e846-f7e3-499e-a2e8-377d1a3ce5f9
DetailsCannot connect to SQL database: 'jdbc:sqlserver://tmssynapse.sql.azuresynapse.net:1433;database={GoogleAdWords_Linked}', 'Managed Identity (factory name): tmssynapse'.[SQL Exception]Error Code:18456, Error Message: Login failed for user '<token-identified principal>'. ClientConnectionId:c6017294-ff0d-4c00-bfdc-910b0715f81f, error stack:shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:283) shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:129) shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5333) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4066) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4004) shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2768) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2418) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2265) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1291) shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:881) com.microsoft.dataflow.store.mssql.CustomSqlServerDriver$$anonfun$3.apply(CustomSqlServerDriver.scala:87) com.microsoft.dataflow.store.mssql.CustomSqlServerDriver$$anonfun$3.apply(CustomSqlServerDriver.scala:87) scala.util.Try$.apply(Try.scala:192) com.microsoft.dataflow.store.mssql.CustomSqlServerDriver.connect(CustomSqlServerDriver.scala:87) org.apache.spark.sql.execution.datasources.jdbc.DriverWrapper.connect(DriverWrapper.scala:45) org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$createConnectionFactory$1.apply(JdbcUtils.scala:63) org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$createConnectionFactory$1.apply(JdbcUtils.scala:54) com.microsoft.dataflow.store.mssql.MSSQLCharacteristic.newConnection(MSSQLStore.scala:101) com.microsoft.dataflow.store.mssql.SQLDWStore$$anonfun$connect$1.apply$mcV$sp(SQLDWStore.scala:127) com.microsoft.dataflow.store.mssql.SQLDWStore$$anonfun$connect$1.apply(SQLDWStore.scala:126) com.microsoft.dataflow.store.mssql.SQLDWStore$$anonfun$connect$1.apply(SQLDWStore.scala:126) scala.util.Try$.apply(Try.scala:192) com.microsoft.dataflow.store.mssql.SQLDWStore$.connect(SQLDWStore.scala:126) com.microsoft.dataflow.transformers.StoreDelegate.connect(StoreDefinition.scala:101) com.microsoft.dataflow.DataflowJobFuture$$anonfun$connect$2.apply(DataflowJobFuture.scala:1083) com.microsoft.dataflow.DataflowJobFuture$$anonfun$connect$2.apply(DataflowJobFuture.scala:1080) scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) java.lang.Thread.run(Thread.java:748)

From <https://web.azuresynapse.net/en/authoring/orchestrate/pipeline/CopyPipeline__Google_Adwords_Campaign_2?workspace=%2Fsubscriptions%2Fae2af841-dd99-493a-8518-91a0d7bc81af%2FresourceGroups%2Fappsvc_linux_centralus%2Fproviders%2FMicrosoft.Synapse%2Fworkspaces%2Ftmssynapse>

This is the pipeline that is using this flow:
185794-image.png

This is the data flow:
185802-image.png

The data preview shows the data:

185759-image.png

This error is happening at the sink:

185774-image.png

Thank you for your help!

Maria Giugno

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,485 questions
{count} vote