SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Instance to Static Port for PHP Application
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ifor
Aged Yak Warrior

595 Posts

Posted - 09/27/2013 :  10:26:17  Show Profile  Reply with Quote
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).aspx

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.

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 09/27/2013 :  13:38:00  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Ifor
Aged Yak Warrior

595 Posts

Posted - 10/01/2013 :  06:24:52  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 10/01/2013 :  12:37:22  Show Profile  Visit tkizer's Homepage  Reply with Quote


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000