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:
1. 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.