How to connect to SQL server on our Intranet
Posted on 2005-03-30
We have an SQL server on our intranet and a web server running IIS which has ASP pages for viewing /editing etc data from the SQL server within the intranet.
The intranet has a connection to the internet via an ADSL router so we have a public dynamic IP and all the intranet pc´s are behind NAT.
Which is the best way to access the SQL server data?
1- Access the intranet by forwarding port 80 on the router to the IIS server (what about security?)
2- Access the intranet SQL server by port forwarding on the router and using enterprise manager to connect remotely?
3- Place some ASP pages on a hosted webserver on the public internet (and these connect to our intranet somehow) and we can access these...
I am very stuck with this and do not know the security implications of each one....