A SQL Server in the DMZ

  • Hi this is my first posting and I need advice on the following:

    SQL Server 2005 Workgroup edition sitting in a DMZ.

    There will be 10 to 15 devices connecting to this sever using encryption (both the server and client will require that encryption be enabled).

    The server and connecting devices will both send and receive data from one another. The server will also need to communicate with our other database servers behind the firewall.

    Can anyone tell me how the SQL Server in the DMZ communicates back to our other servers behind the firewall and so would like to know what the best practice would be.

    Thanks

    J

  • I'm interested in this subject because we're preparing to move a server into a DMZ also. My understanding is that the server in the DMZ shouldn't be able to connect to internal database servers or to pull data from them.

    Since the source for most of the data in the DMZ databases is another, non-SQL Server platform, we're working on a process to push updates to the DMZ server via replication or SSIS.

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply