13
Reply

On Which Port Does Sql Server Runs

Vithal Wadje

Vithal Wadje

10y
2.5k
0
Reply

    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.

    1433

    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