It rather depends what code stack you want to use. Generally, a web application written in most languages can communicate with SQL Server via proper connection drivers. For example, write a web application in C#, Python etc. (what you feel good) and deploy it on a virtual machine or Azure App Services https://azure.microsoft.com/pl-pl/products/app-service/#overview.
Or maybe this can help:
https://learn.microsoft.com/en-us/answers/questions/89295/creating-a-simple-web-site
Please, precise the problem.