Post reply

port number of differnent services

  • July 30, 2009 at 6:49 am

    #140339

    Hello All

    need some suggestion from all of you

    Is all sql services running on differnt Port or Port is depend on instances .

    If yes pl lest us know how can we find the port number of differnent services running on instance

    pls help me

  • July 30, 2009 at 7:57 am

    #1032390

    No 😀

  • July 30, 2009 at 8:25 am

    #1032411

    port number is 1433 by default for a default instance of SQL Server. If you install a named instance, it will grab a different port number by default. You can see what it is using SQL Server Configuration Manager on your server.

    Expand SQL Server 2005 Network

    Click on Protocols for your Instance Name

    Double Click on TCP/IP in the Right Pane to bring up TCP/IP properties

    Click on the IP Addresses tab

    Down at the bottom you will see IPAll

    The Number on TCP Dynamic Ports should be the port number of your instance

    **You can change the port number, but you have to restart the SQL Service for the change to take effect

  • July 30, 2009 at 8:26 am

    #1032413

    Instances use a range to dynamically select a port. You can get the port from the error log of the instance when it starts up, or you can set a specific port in the Configuration Manager for the instance.

  • July 30, 2009 at 11:35 am

    #1032563

    In current SQL Server error log check for this statement: Server is listening on [ xxx.xxx.xxx.1 2392].

    2392 is the port number.

    Or you can also find it in this Registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll

    SQL DBA.

  • July 31, 2009 at 12:45 am

    #1032794

    thank's to all for your valuable input .

    but i need this below info

    1) is all SQL server 2008 services like (reportaing , Analysis Services ) using differnt port ?

    2) if we need to configure differnt port for all sql service then is it possible ?

  • July 31, 2009 at 7:37 am

    #1032921

    Narendra (7/31/2009)

    thank's to all for your valuable input .

    but i need this below info

    1) is all SQL server 2008 services like (reportaing , Analysis Services ) using differnt port ?

    2) if we need to configure differnt port for all sql service then is it possible ?

    Both SSRS and SSAS are eventually going to run from database(s) which are placed under sql server and when a client request comes in it is served through 1433 (default port) otherwise random port selection will be done for named instance (default setting).

    And in the case of named instance it is based on random selection.

    Please make sure you are not confusing yourself with Web Service URL / Report Manager URL settings where you specify a port through which you will be able to access report manager. (eg. http://localhost:8080/ReportManager or http://localhost:8080/Reports.

    hope this helps!

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • July 31, 2009 at 7:58 am

    #1032942

    Configuration Manager can help you set ports

  • July 31, 2009 at 9:49 am

    #1033037

    another thing i should have added to my post is as under.

    To access package stored in msdb database, you must have TCP/IP port 135 open between your machine and the server. This port is a common port used for the Distributed Component Object Model (DCOM), and many network administrators will not have this open by default.

    Rest as steave said can be chacked from config manager.

    Hope it helps!

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

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

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