I have build a Excel maro that could retrieve data from SQL and generate a managment. It works fine within the office.
I want the Excel could work even at home, without building up VPN or Terminal services. However, I don't want to open any port to the SQL Server for external access.
Is it possible to build a Web server with Visual Studio such that users will only call the web services and retrieve the result (recordset) to the users ? How to do the authentication as current, the user will input the user ID and password for our domain ?
Alternatively, is there any other solution to archive this purpose ?