Interactive data access through firewall

Hi there!

I am facing this problem:

I have server A (SQL Server 2005) in LAN and server B (IIS 6) in DMZ.

Due to security policies, server A can initiate communications to B through a firewall; server B cannot initiate any communication to server A.

A web application on server B needs to interactively read/write data stored on server A.

I was reading something about repication, sql everywhere, service broker and something else.

Is there some integrated functionality in SQL Server 2005 that can help in this scenario, or should I develop some sort of sync application?

Thank you.

Bye!

Well, I would not suggest you to implement a sync mechanism on your own. Either use a local database which is replicated to the main server or open the firewall on the dedicated port and restrict the access to the IP of the web server and implement certain security rules like IPSec , using certificate based communication, encryption etc. to prevent any attack to your server.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you for your answer.

I don't know exactly why, but they don't want data to be stored on the published server, nor in any other server in DMZ.

Since I have not much experience in firewalling and network rules, I am trying to adapt my software solution to the existing environment.

I developed a semi-interactive communication app based on asynchronous webservices, where server A polls from server B for queries that should be executed, and returns the resultsets. It's much like Exchange's "Direct Push Emails".

I am just wondering if this is the best solution, or if I should simply pretend some ports be opened on the firewall...