Monday, February 20, 2012

Ports

What ports would I need to open for a web server in a DMZ to communicate
with an internal SQL server?
Peter,
If it is a standard install you would need to open TCP port 1433 (the
default instance) and/or UDP port 1434 on the same ip if you have any apps
that Sql needs to listen for. If Sql is a named instance the port is
dynamically assigned when the instance is first started unless you set an
alternate port during setup. You can also configure/customize these values
using the Client Network Utility.
Hope this helps.
|||Thanks for the advice!
"Brian Brown" <BrianBrown@.discussions.microsoft.com> wrote in message
news:74EABE7C-8E6B-4467-8728-6BEC92BF678E@.microsoft.com...
> Peter,
> If it is a standard install you would need to open TCP port 1433 (the
> default instance) and/or UDP port 1434 on the same ip if you have any apps
> that Sql needs to listen for. If Sql is a named instance the port is
> dynamically assigned when the instance is first started unless you set an
> alternate port during setup. You can also configure/customize these
values
> using the Client Network Utility.
> Hope this helps.

No comments:

Post a Comment