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 ?
The demilitarized zone (DMZ) where you can find filtered traffic from both the inner and the outer network. This zone does not allow any connections directly into the internal network.
Secure Architecture for an SQL / Web Server