How can we access SQL Server hosted on on-premises from Function app

Question

I am trying to access SQL Server hosted on Azure VM from Function app using python. But I am getting this error: Result: Failure Exception: OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

I also created hybrid connection manager to build the connection between SQL Server and function app. but it didn't work.

So Could you please assist me with this?

Answer 1

Hi @Ritika Pandey Greetings! Welcome to Microsoft Q&A forum. Thank you for posting this question here.

Have you tried pinging the SQL Server from outside your VM? It could be possible that port on which your SQL server is hosted is not configured to accept external connections. Please take a look into the firewall configurations of your Azure VM and configure the port to allow inbound connections.

Let me know if this helps.

Answer 2

Hi @Ritika Pandey

Not an expert on Azure Functions app, but from SQL Server side, please check the SQL Server Configuration Manager and make sure that the SQL Server is configured to allow remote connections.

Also, ensure that TCP/IP protocol is enabled for SQL Server.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".