Solved

can 2 instance 1433?

Posted on 2013-05-22
9
306 Views
Last Modified: 2013-06-03
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
Comment
Question by:25112
9 Comments
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 125 total points
ID: 39188540
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
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 125 total points
ID: 39188579
>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
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 125 total points
ID: 39189092
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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 69

Accepted Solution

by:
Qlemo earned 125 total points
ID: 39193586
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
 
LVL 23

Expert Comment

by:nemws1
ID: 39208871
Is there a follow-up question?  What can we help with,  25112?
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39209420
Sorry I missed that, Qlemo, and thanks for pointing it out to me. ;-)
0
 
LVL 5

Author Comment

by:25112
ID: 39216042
appreciate all your input! thanks indeed.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question