question

ETHMAN5 avatar image
ETHMAN5 asked

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.
sql-server-2008sqlserver
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton avatar image
Shawn_Melton answered
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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
3 Likes 3 ·
ThomasRushton avatar image
ThomasRushton answered
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/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
Don't forget about Dynamic ports for NAMED instances.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

... and the opening of ports 2382 (SSAS browser) and 1434 (SQL Browser)...
0 Likes 0 ·
We are plaanig set up all default instances on each environment..
0 Likes 0 ·
SirSQL avatar image
SirSQL answered
If you want to perform distributed transactions you will need to open up additional ports for MSDTC.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.