Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
urdba
Starting Member
5 Posts |
 Posted - 2008-11-10 : 15:59:39
|
| The port 1433 is used for the default instance and UDP 1434 is used for Browser Service.Now my general question is about what static port to use for TCP/IP listner of a named instance of SQL Server 2005? Any port numbers are more secure than others? What is your experience? Any pros/cons? Or do you use dynamic port for named instance?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
urdba
Starting Member
5 Posts |
Posted - 2008-11-10 : 16:52:49
|
quote:
Originally posted by tkizer
Well 1433 shouldn't be used even for the default instance if the application is externally available such as from a web application.The number you pick should be 5 digits and you shouldn't share it with people on the Internet. We never use dynamic ports for any of our instances, static only.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thanks for the response. It is not a web application.What is the benefit of 5 digit port number over the 4 digit port number? Within the 5-digit port number do you have specific recommendation on which one to pick? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
What static port to use for named instance?