Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

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?
0
25112
Asked:
25112
4 Solutions
 
Surendra NathTechnology 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.
0
 
Aneesh RetnakaranDatabase 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
0
 
nemws1Database 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).
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
QlemoC++ 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.
0
 
nemws1Database AdministratorCommented:
Is there a follow-up question?  What can we help with,  25112?
0
 
nemws1Database AdministratorCommented:
Sorry I missed that, Qlemo, and thanks for pointing it out to me. ;-)
0
 
25112Author Commented:
appreciate all your input! thanks indeed.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now