We have an Internet side and an Intranet side. On our internet side, I have a form for the public to fill out and the info goes into a sql database on a seperate sql server.
On our intranet side I have a data access page that connects to the internet sql database through a firewall so that our persons can view and modify records submitted.
The problem is that the data access page cannot connect to the database because the computer itself is trying to connect to the database instead of the intranet web server connecting to the database. The firewall has a hole in it for the intranet web server to get through. Any thoughts or solutions to this?
Thanks
Tom
On our intranet side I have a data access page that connects to the internet sql database through a firewall so that our persons can view and modify records submitted.
The problem is that the data access page cannot connect to the database because the computer itself is trying to connect to the database instead of the intranet web server connecting to the database. The firewall has a hole in it for the intranet web server to get through. Any thoughts or solutions to this?
Thanks
Tom