How to make an API to SQL Server 2012?

Question

SQL Server

The database is spinning on SQLServer 2012, you need to be able to access its data from the web. The ports will be opened, the necessary exceptions will be made in the firewall, the white IP will be registered.
Question: how to do it right? Access some intermediate VB file that will already query the database and display the desired response in the desired format? In this case, the question is how and what kind of intermediate link is better to do (on what technology, programming language, how to implement it).
Or send queries directly to the database, in what form will the answer be then?
API used to do but not with SQLServer ((

Answer 1

SQL Server 2012 Web Edition