x

What are the firewalls and ports needed to open for New SQl server setup

Hi

We are planning to build new project and i need to to know what kind of firewalls and ports required to access Sql server( DB server/SSRS/SSAS/SSIS instance) from any location.
more ▼

asked Jun 20 '11 at 11:46 AM in Default

ETHMAN5 gravatar image

ETHMAN5
472 41 45 48

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

Strangely enough, I blogged this last week, more as a side note to myself.

http://thelonedba.wordpress.com/2011/06/11/ports-for-sql-server-services/
more ▼

answered Jun 20 '11 at 12:06 PM

ThomasRushton gravatar image

ThomasRushton ♦
33.4k 14 20 44

(comments are locked)
10|1200 characters needed characters left
If you want to perform distributed transactions you will need to open up additional ports for MSDTC.
more ▼

answered Jun 20 '11 at 12:29 PM

SirSQL gravatar image

SirSQL
4.8k 1 3

(comments are locked)
10|1200 characters needed characters left

1433 is the default port and suggested port to use for SQL Server.

Little more specific...

Database Engine: http://msdn.microsoft.com/en-us/library/ms177440.aspx

Analysis Service: http://msdn.microsoft.com/en-us/library/ms175638.aspx

Integration Service: http://msdn.microsoft.com/en-us/library/ms137861.aspx
more ▼

answered Jun 20 '11 at 11:53 AM

Shawn_Melton gravatar image

Shawn_Melton
5.3k 17 21 29

Default port for SSIS is 135. For SSRS TCP 80 and 1433 should be enough, and for SSAS it is 2383. Additionally, the high ports above 1024 are needed of you need remote administration. All these are defaults, and thus, the actual configuration might differ.
Jun 20 '11 at 12:00 PM Oleg
(comments are locked)
10|1200 characters needed characters left
Don't forget about Dynamic ports for NAMED instances.
more ▼

answered Jun 20 '11 at 12:12 PM

Tim gravatar image

Tim
35.5k 32 41 138

... and the opening of ports 2382 (SSAS browser) and 1434 (SQL Browser)...
Jun 20 '11 at 12:16 PM ThomasRushton ♦
We are plaanig set up all default instances on each environment..
Jun 20 '11 at 01:11 PM ETHMAN5
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x673
x84

asked: Jun 20 '11 at 11:46 AM

Seen: 1894 times

Last Updated: Jun 20 '11 at 11:46 AM