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 doesnt 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/> ~
