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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-25 : 12:09:45
|
Stephen writes "I have some questions regarding using Data Transformation Services (DTS) between 2 SQL Servers where one resides on a DMZ and the other is on the internal company domain. In this scenario there are restrictions between the ports between the DMZ and internal domain. SQL 7.0 (no service packs) and Windows NT 4.0 SP6a is what is installed on both servers.
The server, the source of the data, is in the DMZ. The destination of the result of the DTS package, that will be used to make a backup copy of the data, will be on a machine in the company domain. This backup will also be used for reporting purposes. Port usage is restricted in that only 2 ports are open between the DMZ and the domain.
What I would like to do is setup SQL Server on the destination PC specifying that the MSSQLServer service use one of the open ports, instead of port 1433 (default), between the DMZ and domain. But one additional issue is that because of security restrictions, the destination PC cannot be browsed via Network Network Neighborhood from the source PC. I would assume that this would mean I would need to specify an IP address of the destination PC when setting up DTS. But when using DTS it asks me for a SQL Server name. Can I specify an IP address instead? Will this still allow DTS to work correctly? Assuming that this would work, would I also need to specify an entry in the Windows NT route table on the source machine so that it would know where to direct the packets since technically these are on 2 different networks?" |
|
|
|
|
|
Performing DTS when a destination server name can't be used