February 2, 2010 at 3:50 am
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
February 2, 2010 at 4:07 am
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/
October 2, 2013 at 12:24 pm
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].
October 2, 2013 at 3:43 pm
Check this article:
http://www.sqlservercentral.com/articles/networking/73238/
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply