Forum Discussion

Pablo82's avatar
Pablo82
Regular Visitor
5 months ago
Solved

Connecting between Fabric SQL Database and Azure Function App

Hello   I currently have a setup of a couple functions residing in an Azure Function App that I would like to write data to a SQL Database within Fabric. I have added the SQL Database as a Service ...
security
v-aatheeque's avatar
v-aatheeque
Community Support
5 months ago

Hi Pablo82 
Thanks for reaching out to Microsoft Fabric Community Forum.

The 'HYT00 Login Timeout expired.' error usually indicates a network connectivity issue rather than a problem with the connection string or code.

 

Since your Function App is integrated with a VNet, please verify the following:

 

  • Ensure the managed private endpoint created by the Service Connector is approved in the Fabric workspace (Workspace -> Networking - Managed private endpoints).
  • Confirm that any NSG or firewall rules allow outbound traffic on TCP port 1433 to the Fabric SQL endpoint.
  • If you are using Managed Identity authentication, make sure the Function App’s identity has been granted access to the Fabric SQL database. You can do this from the Fabric portal by sharing the database with the identity and assigning an appropriate role.

Reference :
 Integrate SQL database in Microsoft Fabric with Service Connector | Microsoft Learn
Connect to Your SQL Database - Microsoft Fabric | Microsoft Learn
Authentication in SQL database - Microsoft Fabric | Microsoft Learn

Hope this helps!!
Thank You.

  • Pablo82's avatar
    Pablo82
    Regular Visitor
    5 months ago

    Hello and thank you for the help so far!

     

    I've gone through your recommendations and can confirm that #3 Managed identity access to Fabric SQL Database is correctly configured. I'm not fully sure what is meant at #1 with the managed private endpoint? I currently only see a connecting string in the environment variables which I assume was generated once I setup the database within the service connector. As for #2 I will check with another department for any other authentication limitations in force for the function apps.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      5 months ago

      Hi  

      Thanks for checking on the Managed Identity configuration, that’s helpful.

      For the networking part, the managed private endpoint refers to a private connectivity setup between your VNet integrated Function App and the Fabric SQL endpoint. If this isn’t configured or approved, the connection may time out (HYT00 Login Timeout expired).

      Regarding the NSG / firewall validation with your internal team, could you please share an estimated timeline for when you expect to have an update on this?

       

      • Pablo82's avatar
        Pablo82
        Regular Visitor
        5 months ago

        Thank you for the extra information! I will take this with me to our company meeting. I expect more information this week!