|
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.
(comments are locked)
|
|
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/
(comments are locked)
|
|
If you want to perform distributed transactions you will need to open up additional ports for MSDTC.
(comments are locked)
|
|
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 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)
|
|
Don't forget about Dynamic ports for NAMED instances. ... 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)
|
