Yes, it was - I was jumping into the middle of this, and, well, they *said* they had done the initial troubleshooting, and I believed them.
Sigh. On Sun, Apr 26, 2009 at 20:39, Ken Schaefer <[email protected]> wrote: > Wasn't one of the first questions asked this one? > > ======== > On Thu, Apr 23, 2009 at 14:58, Tigran K <[email protected]> wrote: >> Are you assuming or know for sure your server is listening on 1433? Run >> netstat to make sure. >> >> --Tigran > > ======== > > Installing SP4 shouldn't make SQL Server start listening on port 1433 - it > should be listening on that straight out-of-the-box. > > Cheers > Ken > > ________________________________________ > From: Kurt Buff [[email protected]] > Sent: Saturday, 25 April 2009 8:34 AM > To: NT System Admin Issues > Subject: Re: SQLServer 200 question - DTS to DMZ > > 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/> ~
