Verified. On Thu, Apr 23, 2009 at 14:58, Tigran K <[email protected]> wrote: > 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/> ~
