Re: Connect to Client SQL

From: Richard Waymire [MSFT] (rwaymi_at_online.microsoft.com)
Date: 12/15/03 

Date: Mon, 15 Dec 2003 07:14:18 -0800

is the connection they're attempting standard or windows authentication? 

-- 
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Prior" <andrew@not-accede.com.au> wrote in message
news:uk1pfGswDHA.3116@tk2msftngp13.phx.gbl...
> Thankyou Richard.  Yes, names are resolved. I have 1433 open all the
way...
> my port scanner can see it no worries.
> I've never set up a server off my own network for an external user to log
> into, so I am worried I am missing something here.  His server is set up
for
> mixed mode logon.  Is there anything else different that would apply to a
> non local user?
>
> Thankyou for your time
>
> Andrew
>
> I'm wondering if the firewall is stopping something else
> "Richard Waymire [MSFT]" <rwaymi@online.microsoft.com> wrote in message
> news:Oa1NuxGwDHA.3744@TK2MSFTNGP11.phx.gbl...
> > If it's a default instance, listening on the default port, yes it should
> > work.  Are you sure name resolution is working?  In other words, you
might
> > try to connect to his IP Address, i.e. "131.107.x.x,1433" as the
> > servername...
> >
> > -- 
> > Richard Waymire, MCSE, MCDBA
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Andrew Prior" <andrew@not-accede.com.au> wrote in message
> > news:u1QOcCFwDHA.1760@TK2MSFTNGP10.phx.gbl...
> > > We happily connect to a couple of SQL databases on ISP servers using
our
> > > Enterprise Manager.  We now have a client who wants us to connect to
his
> > > local SQL server in the same manner and I can't make it work.
> > >
> > > I have 1433 open all the way through the various firewalls etc.  Is
> there
> > > any other port concerned that I might have to open up on his router as
I
> > try
> > > and come in?
> > >
> > > Many thanks
> > >
> > > Andrew
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Strange A Records
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Reverse lookup has 0.in.addr.arpa zone and the name server is listed ...
    (microsoft.public.windows.server.dns)
  • Re: Error
    ... See http://zachd.com/pss/pss.html for some helpful WMP info. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windowsmedia.player)
  • Re: fail to join domain
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Also make sure to use only the domain DNS server on all client ... I got a local LAN domain not connection to internet, ...
    (microsoft.public.windows.server.networking)
  • Re: Not Pulling an IP
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... only reply to Newsgroups ... Is the DHCP server authoriyed in AD and is the scope on the DHCP ...
    (microsoft.public.windows.server.active_directory)
  • Re: Server upgrade.
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Is the new server R2 version? ...
    (microsoft.public.windows.server.migration)