two instances using same port number

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

two instances using same port number

Author

Topic

jdyoumans
Starting Member

4 Posts

Posted - 2010-06-18 : 17:42:03

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

jdyoumans
Starting Member

4 Posts

Posted - 2010-06-24 : 16:01:23

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

JD Youmans

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources