Connect to Client SQL

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
AndrewIf 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...

quote:

---

> 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

quote:

---

> and come in?
> Many thanks
> Andrew
>

---

|||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...

quote:

---

> 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.

quote:

---

> "Andrew Prior" <andrew@.not-accede.com.au> wrote in message
> news:u1QOcCFwDHA.1760@.TK2MSFTNGP10.phx.gbl...
there[QUOTE]
> try
>

---

|||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...

quote:

---

> Thankyou Richard. Yes, names are resolved. I have 1433 open all the

---

way...

quote:

---

> 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

quote:

---

> 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...
might[QUOTE]
> rights.
our[QUOTE]
his[QUOTE]
> there
I[QUOTE]
>

---