Timeline for When is a Dynamic Port "dynamic"?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 15, 2018 at 15:31 | comment | added | kakaz | Would you be so kind to explain why do you think it is worth to implement completely new service ( SQL server browser) which is working on static port so it may not start if this port is used, just because you want to start SQL server in a case where some other services are using ports you are too clumsy to attach to probably the most expensive software you are using? | |
| Aug 6, 2013 at 19:21 | vote | accept | Kenneth Fisher | ||
| Aug 6, 2013 at 19:01 | history | edited | Kin Shah | CC BY-SA 3.0 |
added 1264 characters in body
|
| Aug 6, 2013 at 18:39 | comment | added | Kin Shah |
@KennethFisher for your second question - Every time you start the named SQLServer, it uses the port that is allocated. In case if the port is used by another program then SQL Server chooses another port at the time of restart. The dynamic port is chosen at first startup, and will generally remain the same through future restarts (stored in the Registry) - but if its used by another program then SQL server will choose a new port. note: For Prod Servers, I use only static ports - security and ease of manageability reasons.
|
|
| Aug 6, 2013 at 18:38 | comment | added | Kenneth Fisher |
Thanks and that is a very useful link! Do you know what causes a dynamic port to change ports? See Second question in my question above.
|
|
| Aug 6, 2013 at 18:29 | history | answered | Kin Shah | CC BY-SA 3.0 |