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.