Fabric Notebook Unable To Connect To Azure SQL Server

[awbanksh]

I'm trying to connect a Fabric notebook (PySpark) to Azure SQL server using pyodbc but keep receiving the following error when using ODBC Driver 18 for SQL server: 

OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

Can anyone help? I don't want to input my password into the notebook. 

[awbanksh · Accepted solution]

Notebooks don't support this kind of connectivity.

[v-nikhilan-msft]

Hi @awbanksh ,
Glad you have got a resolution for the error. Please continue using Fabric Community for help regarding your queries.

[DennesTorres]

Hi,

Are you sure a notebook supports interactive authentication? This would be new for me. Try using user and password and don't forget to handle the azure sql firewal

Kind Regards,

Dennes

[v-nikhilan-msft]

Hi @awbanksh ,
Are you still facing this issue? Please let us know if you any issues.
Please refer this link for help: link 

[v-nikhilan-msft]

Hi @awbanksh ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Please let us know if you have any further queries.