Getting connection issue while connecting to Synapse Dedicated pool from Notebook using Linked Service

@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:

1. Check if the connection string property is set correctly in the Linked Service.
2. 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.
3. 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.

@PRADEEPCHEEKATLA-MSFT , 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.

Hi @PRADEEPCHEEKATLA-MSFT , 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.

@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?