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

Question

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:

This is the data flow:

The data preview shows the data:

This error is happening at the sink:

Thank you for your help!

Maria Giugno