Didn't need it - it started working just fine once we applied SQLServer SP4.
Kurt On Mon, Apr 27, 2009 at 10:16, Ziots, Edward <[email protected]> wrote: > Can you use TCPVIEW or Process explorer on the machine the DTS package > is running from and the one in the DMZ and see if any communications are > being tried? > > Z > > Edward Ziots > Network Engineer > Lifespan Organization > MCSE,MCSA,MCP+I, ME, CCA, Security +, Network + > [email protected] > Phone:401-639-3505 > > -----Original Message----- > From: Kurt Buff [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/> ~ > > ~ 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/> ~
