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

Document ID : KB000010759
Last Modified Date : 14/02/2018
Show Technical Document Details
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
Instructions:

 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


    Capture.JPG




  4. On the right side, right click on TCP/IP and choose properties :

    Capture1.JPG


  5. In IP Addresses tab, put this in all IP* sections

    TCP Dynamic Ports =
    TCP port = 1434

    Remarks :
    Change 1434 by the choosen static port
    Put an empty value for all TCP Dynamic Ports fields

     
    Capture2.JPG



  6. Restart SQL Instance

    Capture4.JPG



  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


     Capture5.JPG




  8. Start caf on DOMAIN :

    CAF START