Opinion on best way to access one intranet page from the internet site

We have an onsite cafe and a daily lunch special.  Since we are in a remote area of town we allow the public to also dine here.  We have an internal .asp that makes a call to our MS SQL DB and pulls the daily menu.  Right now when the menu is updated it is scrapped and saved as an html file that is then task scheduled to FTP to the hosted internet site.

Problem is changes are made last minute, etc. so the menu on the internet site is not always current.

What would you suggest as to how to get access to that one .asp intranet page on the internet hosted site without having to open up unnecessary access to the intranet site.

Thanks.
LVL 24
DMTechGrooupAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan McFaddenSystems EngineerCommented:
There are a few choices to solve the problem.  I do not suggest exposing the Intranet website to the Internet, bad security practice.

I can think of the following options:
1. move the publishing process (ftp html file to internet site) into the menu update process.  This makes the scheduled task irrelevant.
2. run Directory/File synchronization software that actively watches the menu html file, when the file is updated, it could execute the ftp push to Internet site.
3. run the FTP scheduled task at a faster frequency (e.g.: every 5 minutes)

Trying to expose a single page is not simple.  You have to open an http or https port on a firewall to allow access to the server.  You can't open those ports (80 or 443) to only a single web page.

You could build a more complex hole thru the firewall that explicitly defined your external web server to have access to your intranet server, but if you are using a shared host, then everything/everyone on that remote server has access.

Dan

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DMTechGrooupAuthor Commented:
THANKS.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.