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', '[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. 

Need Help

5 Replies

  • awbanksh's avatar
    awbanksh
    Microsoft Employee
    2 years ago

    Notebooks don't support this kind of connectivity.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

  • DennesTorres's avatar
    DennesTorres
    Power Participant
    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.