This worked. But, I needed to apply SP4 to SQLServer - whoever installed it didn't put any patches on SQLServer before putting it in the DMZ, so it wasn't listening on port 1433!
IT'S CLOBBERIN' TIME! Sigh. On Fri, Apr 24, 2009 at 06:37, Andy Ognenoff <[email protected]> wrote: > When you put the name in manually, are you sure it's not trying to use Named > Pipes instead of TCP/IP...that could also be why it doesn’t show up when you > search for it. > > I always go into the Client Network Utility on the server running the DTS > package and create a TCP/IP only alias and name it something like > SERVERNAME-IP - usually does the trick. > > - Andy O. > >>-----Original Message----- >>From: Kurt Buff [mailto:[email protected]] >>Sent: Thursday, April 23, 2009 3:53 PM >>To: NT System Admin Issues >>Subject: Re: SQLServer 200 question - DTS to DMZ >> >>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/> ~ > > > > ~ 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/> ~
