Hello Team,

I am trying to read the data from Synapse analytics from databricks.The below is the Query to read the table.

%python

### Read from Azure Synapse table via spark.read.load 

df = spark.read \

 .format("com.databricks.spark.sqldw") \

 .option("url", f"jdbc:sqlserver://xyz.sql.azuresynapse.net:1433;database=Bronze;user=svc_datalakehouse@abc.com;password=qKfb5;encrypt=false;trustServerCertificate=true;hostNameInCertificate=xyz.sql.azuresynapse.net;loginTimeout=60;")\

  .option("tempDir", "abfss://xyz@xyz.dfs.core.windows.net/temp") \

 .option("forwardSparkAzureStorageCredentials", "true") \

 .option("dbTable", tableName) \

 .load()

I am getting error :

Azure Synapse Analytics failed to execute the JDBC query produced by the connector.

Underlying SQLException(s):

- com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "abc.com" requested by the login. The login failed. ClientConnectionId:0995d0ab-c56d-40ac-8fc5-ac514083e38c [ErrorCode = 40532] [SQLState = S0001]

Please advise the solution.

Regards

Rohit