Are you assuming or know for sure your server is listening on 1433? Run netstat to make sure.
--Tigran On Thu, Apr 23, 2009 at 2:41 PM, Kurt Buff <[email protected]> wrote: > 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/> ~ > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
