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.
5,003 questions
Getting connection issue while connecting to Synapse Dedicated pool from Notebook using Linked Service
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Venkateswarlu Pottapalli
0
Reputation points
I am using the Linked service with spn and certificate and test connection is successful. But when I use the same linked service in Synapse Notebook getting below error.
linked service is created for Synapse Analytics and same is working if I change to MSI.
Any solution for this issue?
{count} votes
-
PRADEEPCHEEKATLA 90,231 Reputation points2024-07-08T09:26:54.6333333+00:00 @Venkateswarlu Pottapalli - Thanks for the question and using MS Q&A platform.
It seems like you are facing an issue while connecting to Synapse Dedicated pool from Notebook using Linked Service. Based on the error message you provided, it seems like there is an issue with the connection string property in the Linked Service.
To resolve this issue, you can try the following steps:
- Check if the connection string property is set correctly in the Linked Service.
- Make sure that you have provided the correct values for the properties in the Linked Service, such as server name, database name, authentication type, and credentials.
- If you are still facing the issue, you can try using Managed Service Identity (MSI) instead of SPN and certificate for authentication. You mentioned that the Linked Service is working when you change to MSI, so this could be a viable solution.
For more details, refer to Secure credentials with linked services using the mssparkutils
If none of the above steps work, please provide more information about your environment and the steps you have taken so far, so that I can assist you better.
-
Venkateswarlu Pottapalli 0 Reputation points
2024-07-08T16:37:31.5833333+00:00 @PRADEEPCHEEKATLA , Thanks for the reply.
Linked service connection is proper because I am able to load the data using pipeline but same is not working in notebook.
you can check the connections below.
-
Venkateswarlu Pottapalli 0 Reputation points
2024-07-08T18:29:15.0533333+00:00 Hi @PRADEEPCHEEKATLA , Thanks for the reply.
Linked service configurations are proper because I am able to load the data using pipeline for the same Linked service and issue is happening while using it in notebook.
you can see the below connection properties.
-
PRADEEPCHEEKATLA 90,231 Reputation points
2024-07-11T07:57:50.3833333+00:00 @Venkateswarlu Pottapalli - I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us?
-
PRADEEPCHEEKATLA 90,231 Reputation points
2024-07-18T05:22:35.7166667+00:00 @Venkateswarlu Pottapalli - Did you get a chance to open a support ticket?
Sign in to comment
Sign in to answer