Share via

Unable to connect Synapse SQL Pool via Synapse Notebook through pyodbc using AAD Integrated Authentication

Tomotake Shirakawa 0 Reputation points Microsoft Employee
2023-04-26T08:14:45.8466667+00:00

Im trying to execute "Drop Table" to table on Synapse SQL Pool. After installing pyodbc package on my cluster, executing below command but it gives timeout error. ERROR: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

This worked when I used "SQL Authentication" but it started to give error when using "AAD Integrated Authentication" Does anyone have any idea how to fix this issue? Thank you! User's image

User's image

Azure Synapse Analytics
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.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.