sql-server - Azure Synapse Apache Spark 到 Synapse SQL 连接器错误用户登录失败'

Question

Cannot connect Azure Synapse Apache Spark to Synapse SQL


```
%%spark
import com.microsoft.spark.sqlanalytics.utils.Constants
import org.apache.spark.sql.SqlAnalyticsConnector._

df.write.
option(Constants.SERVER, "servername.database.windows.net").
option(Constants.USER, "xxxx").
option(Constants.PASSWORD, "xxxx").
sqlanalytics("databasename.dbo.TableName", Constants.INTERNAL)
```
I have an error:

`Error : "com.microsoft.sqlserver.jdbc.SQLServerException : Login failed for user '<token-identified principal>'`

我尝试按照 MS 文档中的方式进行操作，但仍然出现相同的错误。 https://docs.microsoft.com/pt-pt/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export#usage

有谁知道该怎么做？

标签： sql-serverscalaazureapache-spark