Post reply

what ports SQL uses

  • December 6, 2012 at 5:12 pm

    #271396

    hi guys, i have not changed anything in my sql server configuration, i know as a default the sql port for an instance is 1433 but when i run master..xp_cmdshell 'netstat -ano' , i don't see that port anywhere, does that mean the ports SQL is running under was changed? What i need to confirm is what ports SQL uses for 1 machine.

  • December 6, 2012 at 5:28 pm

    #1566395

    netstat -abn (with elevated command prompt) will show all ports in use by all applications on the system.

    or

    Launch SQL Server Configuration Manager. Go to SQL Server Network Configuration and look the protocols for <your sql instance name>, then tcp/ip properties and the IP address tab. (This shows the port in use)

    good luck!

  • December 6, 2012 at 6:11 pm

    #1566408

    thanks for prompt answer, when i go to SQL Server Network Configuration , IP address Tab, under IPALL:

    TCPDynamicPort 53244

    TCP Port is blank

    when i run netstat -abn

    TCP 10.78.100.88:53244

    does that mean the port sql has is the default 1433?

    I need to add the port number to open ACLs on the network so my server can communicate to this sql instance.

  • December 6, 2012 at 6:36 pm

    #1566410

    Is it a default instance or is it a named instance?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 6, 2012 at 6:45 pm

    #1566416

    it is a named instance

  • December 6, 2012 at 6:47 pm

    #1566418

    Then open up for the dynamic port you listed.

    Also, open for TCP port 1433.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 6, 2012 at 6:56 pm

    #1566419

    i am sorry now i am confused why for both?, are the tcp port and dynamic port different?

  • December 6, 2012 at 7:23 pm

    #1566423

    Best would be to either change it to a static port or open a range.

    On occasion a Named instance can use port 1433. But it can also use a port from the dynamic range. This is why many will assign a static port to SQL Server instead of allowing it to be dynamic.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 6, 2012 at 7:27 pm

    #1566424

    i understand.. Thank you!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply