My recollection is that you can free-form type in a server name in SQL2K DTS connections. Is that not the case? We have accomplished what you are describing here with no major problems.
-----Original Message----- From: Kurt Buff [mailto:kurt.b...@gmail.com] Sent: Thursday, April 23, 2009 3:58 PM To: NT System Admin Issues Subject: SQLServer 200 question - DTS to DMZ Anyone know how this works? My DBA is trying to set up a DTS connection to push data from our production DB to a SQLServer box in the DMZ. I've got port 1433 open from from the production machine to the DMZ machine, and name resolution is good - I've set up a static DNS entry - but when trying to set up the DTS package through the wizard the machine in the DMZ doesn't appear in the dropdown list, which makes some sense to me as it's a standalone box, not on the domain. I'm also open to the idea that DTS isn't the right way of doing this, but I don't know what the alternatives would be. Any help much appreciated. Kurt ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
