I will try that. I'm not terribly familiar with SQLServer - my last major work on it was back in the 7.0 days, so I appreciate the help.
Kurt 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/> ~
