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

Document ID : KB000010759
Last Modified Date : 14/02/2018
Show Technical Document Details

 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



CA Client Automation - All Versions

 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:


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