can 2 instance 1433?

can 2 sql instance on same machine share 1433 for sql server (TCP).. how does the machine handle this when there is more than one instance running?
Who is Participating?
QlemoConnect With a Mentor Batchelor and DeveloperCommented:
Agree to the "No" statement. Each instance has its own dynamic or static port.

If you use an instance name without a port, the SQL Browser at 1434/udp is asked for the port. Servername is  yourserver\yourinstance.

If you use an instance name with a port, the instance name is ignored, and the port given is used. Servername is yourserver\yourinstance,yourport

If you use a port only, the given port is used. Servername is yourserver,yourport.
Surendra NathConnect With a Mentor Technology LeadCommented:
if you have more than instance installed then you have to pass the instance name to the server while connecting and that is how SQL Server will differentiate which instance it has to connect to.

Note: you need not give any instance name if the default instance.
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
>can 2 sql instance on same machine share 1433 for sql server
No, you have to specify another port fot the second instance

Note: it is recommended not to use the default ports , use some other ports instead of 1433 and 1434
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

nemws1Connect With a Mentor Database AdministratorCommented:
No - you cannot have 2 services on the same incoming port.

Multiple instances are, by default, handled by the SQL Browser (which runs on port 1434).  Additional instances use a dynamic port - changes each time they start up.  They report this port to the SQL Browser and let it handle incoming requests.  This is all great - except when you deal with something that doesn't want to talk to the Browser (like a Linux box).

So, for each instance on a host, you can statically set a port number on it.  For my 2nd, 3rd, etc. instances I usually use ports 1435, 1436, etc.  You can set these via the SQL Server Configuration Manager (SQL Server Network Configuration -> Protocols for Instance_name -> TCP/IP -> IP Addresses Tab -> Blank out "TCP Dynamic Ports" and put a number into "TCP Port" and restart your server).
nemws1Database AdministratorCommented:
Is there a follow-up question?  What can we help with,  25112?
nemws1Database AdministratorCommented:
Sorry I missed that, Qlemo, and thanks for pointing it out to me. ;-)
25112Author Commented:
appreciate all your input! thanks indeed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.