search cancel

How to find the SQL Server Port


Article ID: 33638


Updated On:


CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager


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



<Please see attached file for image>





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

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


<Please see attached file for image>


    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


<Please see attached file for image>

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 :


<Please see attached file for image>



That should help you get the install started.





Release: UASIT.99000-12.9-Asset Intelligence


1558699661923000033638_sktwi1f5rjvs16orr.jpeg get_app
1558699660132000033638_sktwi1f5rjvs16orq.jpeg get_app
1558699658305000033638_sktwi1f5rjvs16orp.jpeg get_app
1558699656199000033638_sktwi1f5rjvs16oro.jpeg get_app