I have a data stored in Microsoft sql 2005 database.. and 2008 version as well
The sql system is in a secured zone.
I have a Microsoft IIS Web server located in the same network as the sql DBs
I have a local computer desktop Windows 7 Enterprise Edition in a diffrent segment/network.
I have an Microsoft Excel version 2010 Application installed in the Desktop
Deskop Windows can access a shared folder in the same network as the DB via a single shared folder.
Desktop Windows can access the webserver via an open http://web
link outside the firewall
What is the best and secured way to access the DB data stored in MSSSQL DB via Excel.. 2010 Application.
Thanks in Advance for your inputs.