June 18, 2010 at 3:46 pm
I have a server with two instances of SQL 2005 (default and named). I need to set them up to have different IP address (done) but the same port. I know this is possible because that is how it was setup before I had to rebuild it.
Now I can't get it going.
Can someone please help me figure this out. I tried this but does not seem to work.
Under SQL Serer 2005 Network Configuration will be a listing for each instance in the right will be a listing of the Protocols.
Under each instance open the properties of TCP/IP
1)Set "Listen All" = No.
2)Set the desired IP and port
3)Disable dynamic ports by removing '0' from TCP Dynamic ports for all IP's except for 127.0.0.1 and "IPAll"
4)Shutdown all instances of SQL
5)Start up all instances of SQL
6)Reboot Server
Did not work. Not sure if I am reading step 3 correctly. Any help greatly appreciated.
JD Youmans
June 24, 2010 at 2:00 pm
Figured it out. Here are the settings. Many thanks to Jonathan Kehayias for pointing me in the right direction.
Default Instance:
Protocol Tab:
Enabled = Yes
Keep Alive = 30000
Listen All = No
No Delay = No
IP Address Tab:
IP1
Active = Yes
Enabled = Yes
IP Address = 10.xx.xx.7
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
IP2
Active = Yes
Enabled = No
IP Address = 127.0.0.1
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
IP3
Active = Yes
Enabled = No
IP Address = 10.xx.xx.7
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
IPAll
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
Named Instance:
Protocol Tab:
Enabled = Yes
Keep Alive = 30000
Listen All = No
No Delay = No
IP Address Tab:
IP1
Active = Yes
Enabled = Yes
IP Address = 10.xx.xx.13
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
IP2
Active = Yes
Enabled = No
IP Address = 127.0.0.1
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
IP3
Active = Yes
Enabled = No
IP Address = 10.xx.xx.13
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
IPAll
TCP Dynamic Ports = <BLANK>
TCP Port = xxxx
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply