Link to home
Start Free TrialLog in
Avatar of itsonlyme4
itsonlyme4

asked on

Configuring a Named Instance to use a static TCP listener port

I have a WIN 2008 R2 Server hosting 4 Different SQL  Server Instances.   I would like to configure one the Instances to listen on a Statis TCP  port - different from the other Instances.   The reason for this is because I have a UNIX client trying to connect to one of the named Instances and being that it's UNIX, they cannot use the '\' in the SQL Server name.    

I figured is I could configure one of the named Instances to listen on a different port, they could just use the connection string  Servername:1435   instead of what they are trying to use now which is  servername\instancename :1433

can anyone help?
SOLUTION
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of itsonlyme4
itsonlyme4

ASKER

Thanks for the link !!!

So,  It looks like I can I change just one of the named instances to use a static port.   what I'm struggling with is how to figure out which of the 12 IP addresses that is displaying in the Configuration Manager under Protocols\TCP\P should I change? I knowwhich is being used for my Default Instance because when I ping my servername (while logged into the server itself) it resolved to this:  
Pinging KOCSQLDEV02.supreme.com [fe80::99b:9351:b7d6:7436%11] with 32 bytes of ...

How to I figure out which IP address to configure as static and assign a port number for my one named instance?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
so that will set ALL named instances to use a different TCP port?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
so for one Instance that I want to change..  for each IP ADDRESS I clear the 0 from the TCP Dynamic ports field and then for IP ALL  I clear the value  59520 from  TCP Dynamic ports and then assign a port number to TCP Port?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Daniel

That is where I am confused.  Under IPALL there are only options for:  

TCP Dynamic Port: 59520
TCP Port:

I've attached a screen shot User generated image User generated image
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Going to try that..   Do I need to stay away from the port numbers associated with the Dynamic pool when assigning a static port?   In other words,   Can I change IPALL for this one named Instance to use Port 59520 ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
daniel,

Thank you for your help (and your patience with me) on this!!!

My named instance is now listening on static port 59521

Server is listening on [ ::1 <ipv6> 59521].
Server is listening on [ 127.0.0.1 <ipv4> 59521].
Dedicated admin connection support was established for listening locally on port 59521.
SQL Server is now ready for client connections. This is an informational message; no user action is required.
You're welcome ;)