Forum Discussion

awbanksh's avatar
awbanksh
Microsoft Employee
2 years ago
Solved

Fabric Notebook Unable To Connect To Azure SQL Server

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',...
Need Help
  • awbanksh's avatar
    awbanksh
    2 years ago

    Notebooks don't support this kind of connectivity.

DennesTorres's avatar
DennesTorres
Impactful Individual
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.