How do you Change a SQL Port from Dynamic to Static ?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

On an ITCM Domain/Enterprise, the Microsoft SQL Server Instance Name and port number are stored in comstore.

If SQL Server Instance is using Dynamic port, port number could change and value in comstore may become wrong.

This could cause problem when some process are using the port found in comstore.

As documented in following docops link, usage of a SQL static port is recommended for ITCM

https://docops.ca.com/ca-client-automation/14-0/en/implementing/installation-of-ca-client-automation/management-database-mdb/preparing-to-work-with-a-microsoft-sql-server-mdb

Environment

CA Client Automation - All Versions

Resolution

 Choose a static TCP port for SQL Server instance. Port for Default SQL Server Instance is generally 1433.

1. In the example below port 1434 will be configured.
   
   
   
   
2. Stop caf on ITCM DOMAIN and all machines with installed remote Engines:
   
   CAF STOP
   
   
   
   
3. On SQL Server, Open  « SQL Server Configuration Manager » and go on SQL Server Network Configuration/Protocols for the instance
   
   
   
   
   
4. On the right side, right click on TCP/IP and choose properties :
   
   
   
   
   
   
   
   
5. In IP Addresses tab, put this in all IP* sections
   
   TCP Dynamic Ports =
   TCP port = 1434
   
   Remarks :
   Change 1434 by the chosen static port
   Put an empty value for all TCP Dynamic Ports fields
   
    
   
   
   
   
   
6. Restart SQL Instance
   
   
   
   
   
   
7. On DOMAIN ITCM execute this command to update the SQL port number in comstore (adapt the command line with the choosen port number) :
   
   ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbmsinstance -v ITCM1,1434
   
    
   
   
   
   
8. Start caf on DOMAIN :

CAF START