Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sir_izhael
Starting Member
1 Post |
 Posted - 2007-10-22 : 08:31:45
|
| Hi,We want to create an Internet sealing system. The web server where the site is located isn’t owned by our company however the SQL server that contains reservation data is in our Local Area Network. In the beginning, due to security reasons, we considered to set another SQL Server 2000 in our DMZ and update our internal SQL Server through Replication. We’ve been highly recommended to use Web Services instead of Replication. Replication has been let out; however, I’m thinking of setting a SQL Server in the DMZ which only has stored procedures that update our Internal database (The database which contains reservation data). What’s your opinion about this? I know that Web Services is the best choice but I would like to know if it’s a good alternative.Thanks in advance... |
|
|
csundaresh
Starting Member
5 Posts |
Posted - 2007-10-24 : 10:40:28
|
| In order for the SQL Server in DMZ to update data in your internal SQL Sever you will need to create a trusted connection. Instead of trying to secure this connection and your SQL server on DMZ, you are better off using Web Services. |
 |
|
|
|
|
|
Please Help needed!!!