I've opened port 1433 from the production network to the DMZ, and not vice versa, and not any other ports either.
Reading the MSFT article, they imply, obscurely, that I should expect responses back on random ports < 1024. I just want to be able to push data to the DMZ, and pull it from the DMZ. The machine in the DMZ should never initiate a conversation, and starting or continuing a conversation on another port doesn't fit that model. I didn't read the other article, as I'm not going to give data to a pay-for site. On Thu, Apr 23, 2009 at 13:23, Christopher Bodnar <[email protected]> wrote: > 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/> ~ > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
