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 ?



    All versions of CA Client Automation

    All version of Windows and SQL



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






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

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


    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 :



That should help you get the install started.