Forum Discussion
JasonB35
Apr 14, 2022Copper Contributor
I am unable to connect SQL serverless Built-in pool with SQL Server Management Studio?
Hi I have my CSV file in the Azure data lake gen 2. I created an external table for this CSV file in SQL Serverless Pool and I am able to read the table in the Azure Synapse notebook. However, g...
- Apr 27, 2022
Hi, JasonB35,
The error that is shown on linked thread is usually related to file permissions. Make sure that you have permissions on storage account and file itself. Query fails because file cannot be opened.
Bonus things to check:
- Can you run queries on top of the external table from Synapse studio?
- If you can, and can’t run queries from SSMS, are you logging in as the same AAD user which you're using from Synapse studio?
- Can you double check their connection string to make sure you're logging in to proper serverless SQL pool from SSMS?
- Visit control storage account access for serverless SQL pool to learn more about this topic.
StrahinjaRodic
Microsoft
Apr 27, 2022Hi, JasonB35,
The error that is shown on linked thread is usually related to file permissions. Make sure that you have permissions on storage account and file itself. Query fails because file cannot be opened.
Bonus things to check:
- Can you run queries on top of the external table from Synapse studio?
- If you can, and can’t run queries from SSMS, are you logging in as the same AAD user which you're using from Synapse studio?
- Can you double check their connection string to make sure you're logging in to proper serverless SQL pool from SSMS?
- Visit control storage account access for serverless SQL pool to learn more about this topic.