Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Named Instance port number Expand / Collapse
Author
Message
Posted Tuesday, February 2, 2010 3:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, October 13, 2014 1:58 PM
Points: 753, Visits: 1,070
Hi,

I have a default instance of SQL Server 2005 and 3 named instances.

I know that by default a named instance is on port 1433 and i know too that the browser service is on port 1434.

What about the other named instances ? how can i see in wich port they are?


I need this , because i need to open in the firewall the port 1433,1434 and the ports of the other instances, otherwise people can not connect (i think).


Thank you
Post #857817
Posted Tuesday, February 2, 2010 4:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 1:05 AM
Points: 2,112, Visits: 5,489
You can use the SQL Server configuration manager to check which port is used by any of the instances that you have on the server. Notice that the default behavior is to use dynamic port allocation (e.g. each time that the service starts, it will use a different port). Since you need to enable work on the ports in the firewall, you should modify this behavior and assign a permanent port for each instance. You can do that from the SQL Server configuration manager.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #857824
Posted Wednesday, October 2, 2013 12:24 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 142, Visits: 922
Your current sql server log will show an informational message about which port it is using.

Message is about 20 entries from the beginning of the file.

Server is listening on [ 'any' <ipv4> 1328].
Post #1500878
Posted Wednesday, October 2, 2013 3:43 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:58 PM
Points: 1,341, Visits: 2,864
Check this article:

http://www.sqlservercentral.com/articles/networking/73238/


----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.
Post #1500946
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse