Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Port numbers 1433 and 1434 Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 11:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 4, 2014 5:42 PM
Points: 235, Visits: 983
Hi DBA's

why there are two ports 1433 and 1434 for SQL Server.
whts the purpose of two?
how are they different?

I came to know 1433 is for TCP\IP
1434 for UDP what does this mean ?

Thanks in advance!
Post #1341420
Posted Tuesday, August 7, 2012 11:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:22 PM
Points: 20,680, Visits: 32,279
Sqlism (8/7/2012)
Hi DBA's

why there are two ports 1433 and 1434 for SQL Server.
whts the purpose of two?
how are they different?

I came to know 1433 is for TCP\IP
1434 for UDP what does this mean ?

Thanks in advance!


The default instance of SQL Server listens on Port 1433. Port 1434 is used by the SQL Browser Service which allows connections to named instances of SQL Server that use dynamic ports with out having to know what port each named instance is using, especially since this can change between restarts of the named instance.

Books Online should provide more details.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1341423
Posted Tuesday, August 7, 2012 11:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 3:18 AM
Points: 20, Visits: 412
Hi,

When SQL Server 2000 and SQL Server 2005 clients request SQL Server resources on a named instance, the client network library sends a UDP message to the server using port 1434

Please go through with the below URL for detail
http://msdn.microsoft.com/en-us/library/ms175483(v=sql.90).aspx

Thanks,
Mohammed
Post #1341445
Posted Tuesday, August 7, 2012 11:50 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:22 PM
Points: 20,680, Visits: 32,279
Mohammedr_mcts (8/7/2012)
Hi,

When SQL Server 2000 and SQL Server 2005 clients request SQL Server resources on a named instance, the client network library sends a UDP message to the server using port 1434

Please go through with the below URL for detail
http://msdn.microsoft.com/en-us/library/ms175483(v=sql.90).aspx

Thanks,
Mohammed


Let's make it easier for others:

http://msdn.microsoft.com/en-us/library/ms175483(v=sql.90).aspx



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1341449
Posted Tuesday, August 7, 2012 3:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 6,370, Visits: 13,709
Sqlism (8/7/2012)
Hi DBA's

why there are two ports 1433 and 1434 for SQL Server.
whts the purpose of two?
how are they different?

I came to know 1433 is for TCP\IP
1434 for UDP what does this mean ?

Thanks in advance!

you don't have to use TCP\UDP 1434, you can just connect using IP,portnumber

e.g.
10.10.10.45, 1528


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1341563
Posted Tuesday, August 7, 2012 9:13 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
One more note. By default , DAC uses 1434 port.
Post #1341660
Posted Monday, August 12, 2013 8:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, January 4, 2014 5:07 AM
Points: 17, Visits: 28
Enterprise Edition (64-bit) how much memory used in widows server 2008 r2 Enterprise edition
Post #1483352
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse