How to find the SQL Server Port

book

Article ID: 33638

calendar_today

Updated On:

Products

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

Issue/Introduction

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>

program.jpg

 

 

 

     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>

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

                     

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

regedit.jpg  

 

That should help you get the install started.

 

 

 

Environment

Release: UASIT.99000-12.9-Asset Intelligence
Component:

Attachments

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