it depends on whether or not you have set your Client Network
Configuration to use TCP/IP or Named Pipes by default. You can do this
by setting it to use TCP/IP, and then port 1433 (or whatever you want,
if you change it on the server side).
I would think very carefully about the architecture decisions which
require this. Its a risky decision to allow this through a firewall;
its a topic of much discussion and most resolutions require compromise
and heartache (the yin and yang of network design, actually.)
Good luck,
Henry
> -----Original Message-----
> From: Michael Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 15, 2000 9:52 AM
> To: Bill Stewart
> Cc: Firewalls (E-mail)
> Subject: Re: SQL 7.0 through a firewall
>
>
> SQLEM seems to use RPC over Named Pipes (over SMB) to talk to
> the server.
>
> On Fri, 15 Dec 2000, Bill Stewart wrote:
>
> > Does anyone know if it is possible to connect to a MS SQL
> 7.0 server through
> > a firewall? I need to register a server in Enterprise
> Manager over the
> > Internet. I have opened up TCP/UDP 1433 but I can not
> connect. I can
> > connect using Query analyzer but not with Enterprise
> Manager. Can this be
> > done?
>
> -
> [To unsubscribe, send mail to [EMAIL PROTECTED] with
> "unsubscribe firewalls" in the body of the message.]
>
-
[To unsubscribe, send mail to [EMAIL PROTECTED] with
"unsubscribe firewalls" in the body of the message.]
