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

<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>

   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
Component: