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 |
|
Ifor
Aged Yak Warrior
700 Posts |
 Posted - 2013-09-27 : 10:26:17
|
| I have a box with three instances of SQL2008R2 and have been asked to change one instance so it uses a static port, 63052, to enable a PHP application to connect. As I have only ever used Microsoft technologies to connect to SQL Server, I am getting confused. I have read the following and have a number of questions:http://technet.microsoft.com/en-us/library/ms177440(v=sql.105).aspx1. It looks as though I need to get rid of the 0 (zero) for 'TCP Dynamic Ports' and set 'TCP Port' to 63052 for IP1 to IP8.- Do I need to do this for IP6 which has the loopback IP address of 127.0.0.1?- Do I need to set 'TCP Port' to 63052 for IPAll?2. If I set a static port for one instance, do I need to set a static port for all the instances on the box in order to avoid potential conflicts if the machine is restarted?3. Are there other implications in setting static ports?As there are ten production databases on the instance I do not want to play around too much.We have an 'at risk' period between 7am and 9am BST on Tuesday so I would be grateful for any information received by then. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-09-27 : 13:38:00
|
| Just scroll all the way to the bottom and modify the IPAll section. Blank out the "TCP Dynamic Ports" field and then type in your port for "TCP Port". Restart SQL.I use static ports on all of my SQL instances because there are firewalls and external access through web servers.No implications except perhaps firewall holes.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2013-10-01 : 06:24:52
|
| Thanks for the information.Just to let you know, I applied the changes earlier today and then restarted the machine. (Security patches had to be applied anyway.)Everything seems to be working okay. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Instance to Static Port for PHP Application
Tara Kizer