On Which Port Does Sql Server Runs
Vithal Wadje
The Default port is 1433 for TCP/IP and 1434 for USD connection.
The default port is 1433 (TCP). But you can configure the SQL DB engine to listen the port you want.
By default it is 1433.to know port number follow the below steps in the registry section HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp
Default Port for Sqlserver : 1433 for TCP/IP and 1434 for USD connection. -------------------------------------------------------------------------------- Method 1: using xp_readerrorlog: Execute following stored procedure on the instance where you want to find out port on which SQL Server is running. USE MASTER GO xp_readerrorlog 0, 1, N'Server is listening on' GO -------------------------------------------------------------- Method 2: Configuration Properties a)Go to Windows >> Start >> SQL Server Program Folder >> SQL Server Configuration Manager b)Now go to SQL Server Network Configurations >> Protocols for Your c)Server and go to TCP/IP and right click over it. Now when you scroll down you will notice Port Details.
Default port is 1433 for TCP/IP and 1434 for USD connection.
1433
Default Port for SQL server is 1433.
IPv6 loopback and IPv4 loopback port(1434) IPv6 unspecified and IPv4 unspecified port(1433)
USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO
use default port no 1433
yes,TCP 1433