13
Reply

On Which Port Does Sql Server Runs

Vithal Wadje

Vithal Wadje

Nov 03, 2014
2.5k
0

    The Default port is 1433 for TCP/IP and 1434 for USD connection.

    Ashu Bahl
    November 18, 2014
    2

    The default port is 1433 (TCP). But you can configure the SQL DB engine to listen the port you want.

    Jaganathan Bantheswaran
    November 04, 2014
    2

    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

    Yadagiri Reddy
    November 19, 2014
    1

    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.

    Rohit Vyas
    December 17, 2014
    0

    Default port is 1433 for TCP/IP and 1434 for USD connection.

    Alok Gupta
    December 10, 2014
    0

    1433

    Garima Jain
    December 08, 2014
    0

    Default Port for SQL server is 1433.

    Garima Jain
    December 08, 2014
    0

    1433

    Naresh
    December 02, 2014
    0

    1433

    Shweta Lodha
    November 19, 2014
    0

    IPv6 loopback and IPv4 loopback port(1434) IPv6 unspecified and IPv4 unspecified port(1433)

    Pulak deb
    November 12, 2014
    0

    USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO

    Munesh Sharma
    November 06, 2014
    0

    use default port no 1433

    Vishvajeet Pawar
    November 04, 2014
    0

    yes,TCP 1433

    Vithal Wadje
    November 04, 2014
    0