We are able to specify the name of the machine manually while setting up the DTS package in the Administrator GUI, but when connecting it comes back with "Error 11: General network error. Check your network documentation." and I get no further.
Kurt On Thu, Apr 23, 2009 at 13:24, Mayo, Bill <[email protected]> wrote: > My recollection is that you can free-form type in a server name in SQL2K > DTS connections. Is that not the case? We have accomplished what you > are describing here with no major problems. > > -----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/> ~
