Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

I need to know the default port settings for the following services

  1. SQL Server
  2. SQL Browser
  3. SQL Reporting services
  4. SQL Analysis services

I neeed to know the port settings for these services for different versions of SQL Server (2000,2005,2008)

Also let me know whether the default port setting will change based on sql server versions

Thanks in advance.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
407 views
Welcome To Ask or Share your Answers For Others

1 Answer

  1. The default SQL Server port is 1433 but only if it's a default install. Named instances get a random port number.

  2. The browser service runs on port UDP 1434.

  3. Reporting services is a web service - so it's port 80, or 443 if it's SSL enabled.

  4. Analysis services is 2382 but only if it's a default install. Named instances get a random port number.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...