How to find the SQL Server Port

Document ID : KB000033638
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:  When Installing or Upgrading CA Client Automation how can I tell what SQL Instance and Port of your MDB is installed on ?

 

Environment:

    All versions of CA Client Automation

    All version of Windows and SQL

 

Answer:

1. Upgrading  - Run these 2 comstore commands to find the Server Name and Instance and Port:

To show the Server Name:

            ccnfcmda -cmd getparametervalue -ps itrm/database/default -pn dbmsserver

To show the Instane and port:

 

            ccnfcmda -cmd getParameterValue -ps itrm/database/default/ -pn dbmsinstance

 

 

1. Fresh Install  - There are 2 ways to check the for the Port (Both must be performed on the SQL server)

 

   A. Check the SQL Server Configuration Manager 

 

       1.) From the Start Menu -> Microsoft SQL Server <version> -> Configuration Tools ->

 

             Open SQL Server Configuration Manager

 

                          program.jpg

 

 

 

     2.) Expand SQL Server Network Configuration -> Protocols for <Instance>

          Then on Right-hand side  Right-Click on TCP/IP -> Properties 

                    instance.jpg

    3.) On TCP/IP Properties screen, go to IP Address Tab->

         Scan down to bottom of Screen.

         The Port will be listed in the IPAll Section for TCP Dynamic Ports or TCP Port

         In my Example: The Port is :  55671

                     TCP prop.jpg

 

   B. Registry - The 2nd way to check the port is looking in the registry.

       Each version of SQL has it's own place in the Registry to store the value of the Port, 

       I would Google where the SQL Port is Located in the registry.

 

         Here is an Example of where it is for SQL 2012 :

                        regedit.jpg  

 

That should help you get the install started.