Have you looked at this: http://support.microsoft.com/default.aspx?scid=kb;en-us;287932&Product=sql 2k
This might be helpful as well: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_2156 5788.html Chris Bodnar, MCSE Sr. Systems Engineer Distributed Systems Service Delivery - Intel Services Guardian Life Insurance Company of America Email: [email protected] Phone: 610-807-6459 Fax: 610-807-6003 -----Original Message----- From: [email protected] [mailto:[email protected]] 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/> ~ ----------------------------------------- This message, and any attachments to it, may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are notified that any use, dissemination, distribution, copying, or communication of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail and delete the message and any attachments. Thank you. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
